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


Please Help Members By Posting Answers For Below Questions

What is the difference between Active and Passive transformation?

637


explan ur project architecture?

1599


How to create Target definition for flat files?

754


What is joiner transformation?

585


Define the various join types of joiner transformation?

561






Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

787


How to generate sequence numbers without using the sequence generator transformation?

649


What is a filter transformation?

571


Explain pushdown optimization and types in informatica

670


is it possible to index the data in cache of lkp transformation ?

1528


How can you define user defied event?

622


What is union transformation?

575


What is domain and gateway node?

699


What are the different components of powercenter?

584


What is Session and Batches?

666