Answer Posted / raveendra guturi
Union: while we have to join two sources should data
structure same.
)Joiner is active transformation
Lookup is a passive transformation
2)In joiner we can join two heterogeneous sources for
entire Records based on a condition.
But in look up only the first value or last value of the
Records will be passed if more records matched with that
condition. So only one value will be returned to the
transformation.
3)If we need entire values we must go for joiner. Take that
look up table as source and use joiner. No alternative
Solution.
4) Joiner operates on source
Lookup operates on source and target level
5) Joiner does not support non-eqijoin its support equijoin.
Lookup supports non-equijoin
6) Joiner doesnot match for null values
Lookup supports null values
7) join supports only = operator
Lookup supports <=,>=,=,1= operators
9) Joiner supports outer join but lookup doesnot.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How do you take back up of repository?
Describe expression transformation?
Explain what are the different versions of informatica?
Explain about cumulative Sum or moving sum?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What will be the approach?
Define filter transformation?
Mention few advantages of router transformation over filter transformation.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
What is a connected transformation?
Explain direct and indirect flat file loading (source file type) - informatica
what is the -ve test case in your project.
how many types of dimensions are available in informatica?
