RE: when we create a target as flat file and source as...
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
RE: when we create a target as flat file and source as...
to the result set that's going to be loaded in to falt file..add a row with col names to that result set..either by pre sql or by joiner transformation..if ti wroks please let me know..thanks
RE: when we create a target as flat file and source as...
Hi,
For getting the column names in the flat files, you need to make changes in the Informatica server setup. Under Informatica Server setup-> under configuration there is a option you need to check, Output Metadata for target flat files.
RE: when we create a target as flat file and source as...
Hi,
Create two file targets,the first target is loaded with the hardcoded column names and in the second file with actual values.In that particualr session there is a post session command in that we have merge the two file using unix cat command. so the format will be first row appears with all the column names and from second row it displays the actual values.
