i have headers separately, how to import it to informatica target

Question

I have source and target in an informatica powercenter developer. I heed some other header name to be imported in the target file automatically without any manual entry. How can I import customized headers to informatica target.

Answer 1

The logic is, In session command, there is an option called user defined headers. Type echo followed by column name separated by comma delimited

echo A, B, C

Answer 2

What have you tried?

You can use a header command in the session configuration for the target, I haven't used it, and couldn't find any documentation on it (i.e. what is possible and how, whether parameters can be used or not, etc.). I did test using (on Windows) an ECHO command to output its text to the header row, but it didn't seem to recognize parameters.

Or you can try to include the header as the first data output row. That means your output will have to be all string types and length restrictions may compound the issue.

Or you can try using two mappings, one that truncates the files and writes the header and one which outputs the data specifying append in the session. You may need two target definitions pointing to the same files. I don't know if the second mapping would attempt to load the existing data (i.e. typecheck), in which case it might throw an error if it didn't match.

Other options may be possible, we don't do much with flat files.