how to join the 2 different table with different columns in
informatica?

Answer Posted / sanjay

1.By using UNION transformation we can join 2 different
table with different columns in informatica....

2.By using Sequence generator on both tables, we can join 2
different table with different columns in informatica....

Is This Answer Correct ?    1 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain one complex mapping with logic? sales project?

6154


Explain the code page compatibility?

644


What is an Integration service in Informatica?

706


What is an expression transformation?

594


which one is better performance wise joiner or look up

630






What is data caches/ index caches?

617


what is the size of u r source(like file or table)?

1818


Mention some types of transformation?

607


What is target designer and target load order?

660


What are 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?

600


What is the Rank index port in Rank transformation?

672


what are factless facts? And in which scenario will you use such kinds of fact tables.

1317


How big was your fact table

1322


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

1528


How do you take back up of repository?

723