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





use a pre sql statement....but this is a hardcoding 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 achive 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

No comments:

Post a Comment