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

What is a node in Informatica?

617


tell me the rules and responsblites in our project(my project is development)

1491


What is sorter transformation?

576


How to call shell scripts from informatica?

570


How identifying bottlenecks in various components of informatica and resolving them?

577






what are 3 tech challenges/ common issues you face?

1880


What is target load order?

802


What does reusable transformation mean?

668


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

617


What is data transformation manager process?

616


Explain constraint based loading in informatica

654


If informatica has its scheduler why using third party scheduler?

765


Explain what are the different types of transformation available in informatica.

567


What is the difference between a connected look up and unconnected lookup?

566


Sequence generator, when you move from develoment to production how will you reset

1397