InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
When We Create A Target As Flat File And Source As Oracle. How Can I Specify First Rows As Column Names In Flat Files? |
|
Answer» 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. 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. |
|