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
explain one complex mapping with logic? sales project?
Explain the code page compatibility?
What is an Integration service in Informatica?
What is an expression transformation?
which one is better performance wise joiner or look up
What is data caches/ index caches?
what is the size of u r source(like file or table)?
Mention some types of transformation?
What is target designer and target load order?
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?
What is the Rank index port in Rank transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How big was your fact table
is it possible to index the data in cache of lkp transformation ?
How do you take back up of repository?