explain abt joiner t/r?



explain abt joiner t/r?..

Answer / 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

More Informatica Interview Questions

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,


What are the designer tools for creating tranformations?

1 Answers   Informatica,


What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers   Informatica,


When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,


we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,






What is a snowflake schema?

0 Answers  


Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers  


source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,


Which is the t/r that builts only single cache memory?

0 Answers  


what are the deliverables?in your project?

0 Answers   DELL,


After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,


What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,


Categories