how we can add header and footer to flat files?
Answers were Sorted based on User's Feedback
Answer / sidhu
in session properties,
select mapping tab then
select target properties
there header and footer command option
there u give
echo header in header option
and echo footer in footer option
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / mukesh kumar
go to session edit>>>>mapping tab>>>>>>>selct
source>>>>>>in header command option and footer command
option type the command
Is This Answer Correct ? | 7 Yes | 4 No |
is it possible to index the data in cache of lkp transformation ?
What is a shortcut and copy in Informatica and how two are different with each other?
What do you understand by SOA of Informatica?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
what is session override?
How the informatica server increases the session performance through partitioning the source?
What is update strategy transform?
What is pmcmd command?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Why use shortcuts(Instead of making copies).
What all join we can perform in LOOKUP transformation?