Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Experts,
Performance Wise Which transformation is better in LOOKUP
AND JOINER TRansformations? Why? Can anybody please explain
it ?
Please help me out from this Question.
Thanks In Advance.
- 2 Answers
- 14083 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / raj
the lookup and joiner t/r can be used to join two sources data.
if u r using one source is flat file and another source is database source then we can use joiner is better.i.e heterogeneous join.it is not possible with the help of lookup.
if two sources are in the same database lookup is better.
| Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
What is persistent lookup cache?
Which transformation is needed while using the Cobol sources as source definitions?
What is a joiner transformation and why it is an active one?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the main features of Oracle 8i with context to datawarehouse?
How we can create indexes after completing the load process?
Different sorts of metadata that stores in the storage facility?
What is meant by lookup transformation? Explain the types of lookup transformation?
Which development components of informatica have the highest usage?
What is target load order?
4 yrs etl devloper roles and responsibilities?any body give solutions
How can one identify whether mapping is correct or not without connecting session?
my source is junk data how will u remove that junk data by using unix please any one replay me
How to extract sap data using informatica?
How would you copy the content of one repository to another repository?
