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
- 13949 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
How many types of sessions are there in informatica.please explain them?
Mention few advantages of router transformation over filter transformation.
How to convert multiple rows to single row (multiple columns) in informatica
Which are the different editions of informatica powercenter that are available?
Explain the mapping variable usage example in informatica
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to use procedural logic inside infromatica?
can we override a native sql query within informatica? How do we do it?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Slowly changing dimensions, types and where will you use them
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How do you load alternate records into different tables through mapping flow?
What is the need of an ETL tool?
How do you change a non-reusable transformation to reusable transformation?
How to Create a folder using pmrep command?
