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 create dummy port for each source Qual. then connect
to Join Trans., and Join two dummy port.in Joiner
Transformation.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where do we use mapping variables in informatica?

618


have u done any performance tuning? how u ll do?

1861


without table how to come first record only in oracle?

1858


lookup transformation with screenshots

3559


What is substr in informatica?

663






What is meant by active and passive transformation?

587


what is the hint? how to use it to reduce the query processing in program?

6320


What are junk dimensions?

635


What are some examples of informatica etl programs?

537


Briefly describe lookup transformation?

601


What is the fact table?

593


What is joiner transformation in informatica?

629


While migrating the data from one environment to another environment how would you manage the connections?

627


Explain what is informatica metadata and where is it stored?

612


What does reusable transformation mean?

676