Input flatfile1 has 5 columns, faltfile2 has 3 columns(no
common column)
output should contain merged data(8 columns)
Please let me know how to achieve ??
Answer Posted / moorthy g
You Can Use Union Transformation for combine two flat files
| Is This Answer Correct ? | 1 Yes | 14 No |
Post New Answer View All Answers
Differentiate between a repository server and a powerhouse?
What is the session task and command task?
How to create Target definition for flat files?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is parallel processing in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are roles and groups and benefits of using them?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Explain the pipeline partition with real time example?
What is a difference between complete, stop and abort?
What is the need for an etl tool?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the popular informatica products?
Explain sessions?
What is an Integration service in Informatica?