Interested to Buy Any Domain ? << Click Here >> for more details...
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 manage the Parameter files while migrating your data from one environment to another environment?
Differentiate between a database and data warehouse?
What is session task and command task?
Explain the features of connected and unconnected lookup.
What is the surrogate key?
Informatica settings are available in which file?
How to join three sources using joiner? Explain though mapping flow.
How is union transformation utilized?
What is olap (on-line analytical processing?
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
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
Briefly define a session task?
What is the fact table?
How can a transformation be made reusable?
What are the advantages of informatica?
