Answer Posted / suraj kedia
Joiner transformation is used to join source data from two
related heterogeneous sources. However this can also be used
to join data from the same source. Joiner t/r join sources
with at least one matching column. It uses a condition that
matches one or more pair of columns between the 2 sources.
To configure a Joiner t/r various settings that we do
are as below:
1)Master and detail source
2)Type of join
3)Condition of the join
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Define mapping and session?
Define the various join types of joiner transformation?
How might you approve all mappings in the archive all the while?
What can we do to improve the performance of informatica aggregator transformation?
What are the differences between a connected lookup and unconnected lookup?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the different types of olap? Give an example?
What is the function of union transformation?
Under which circumstances, informatica server creates reject files?
how we can load rejected record's at run time?(not through bad files)
What is the need for an etl tool?
How an expression transformation differs from aggregator transformation?
What is blocking transformation?
my source is junk data how will u remove that junk data by using unix please any one replay me
