HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?
Answer Posted / murali udayagiri
Use join UNIX command in pre-session command for joining
both the files and write to a file. Use single SQ trans in
mapping to read that joined flat file data.
Thanks,
Murali Udayagiri
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What does command task mean?
What are the components of workflow manager?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to Create a folder using pmrep command?
What is the need of etl tools?
Differentiate between Load Manager and DTM?
Describe the impact of several join conditions and join order in a joiner transformation?
What is a router transformation?
What is mapplet in informatica?
What are the tasks that source qualifier perform?
What is transformation?
What is blocking transformation?
What is source qualifier transformation in informatica?
How to update source definition?
How to create the list file having millions of flat files while indirect loading in 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?