Question
When we create a target as flat file and source as oracle. How can i specify first rows as column names in flat files?

Answers

Use a pre sql statement., but this is a hard coding method. If you change the column names or put in extra columns in the flat file, you will have to change the insert statement.
You can also achieve this by changing the setting in the Informatica Repository manager to display the columns heading. The only disadvantage of this is that it will be applied on all the files that will be generated by this server.   Your Comment






Search
Can you Answer!!
  • Q What is an interrupts? Who generates interrupts? How are interrupts handled by an operating system?
  • Q Explain about backup types
  • Q Can you explain the broader steps of how L2F establishes the tunnel?
  • Q In which year was the concept of 'Zero Hour' introduced in the Indian Parliament?
  • Q Can i thenreturn() an inlined mock() ?
  • Q What are the general services supported?
  • Q SQL Server 2008 introduces automatic auditing
  • Q The European/Asian slow worm (Anguis) is what sort of animal: Snake; Lizard; Eel; or Earthworm?
  • Q What is default value of "vbroker.agent.keepalivetimer" property?
  • Q The UDP protocol is
  • Q International Day Against Drug Abuse and Illicit Trafficking was observed on……….?