Interested to Buy Any Domain ? << Click Here >> for more details...
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
How would you copy the content of one repository to another repository?
What is the difference between writing a joiner query in ANSI style and THETA style?
How can we update a record in the target table without using update strategy?
What do you mean by enterprise data warehousing?
Mention a few design and development best practices for informatica?
What is an unconnected transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What does “tail –f” command do and what is its use as an Informatica admin.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the use of code page?
How to update a particular record in target with out running whole workflow?
State the limitations where we cannot use joiner in the mapping pipeline?
pmscmd startworkflow -sv
What are the different options available for update strategy?
