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
What do you mean by enterprise data warehousing?
What is the difference between Active and Passive transformation?
tell me about your project functionality
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How to extract the informatica rejected data?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the types of schemas we have in data warehouse.
What is domain in terms of informatica?
What is meant by pre and post session shell command?
Why update strategy and union transformations are active? Explain with examples.
What does “tail –f” command do and what is its use as an Informatica admin.
what is the Default Source Option For Update Strategy Transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to do unit testing in informatica? How to load data in informatica ?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use