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
- 13061 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Look up will better perform because the cache is initially
created when the first record will reach at Look up
tarnsformation and the further records are work upon the
cached records.Look up will perfrom left outer Join
only.Other Joins can't be posible.You can check the records
are either exists in the lookup table or not.
Jioner will be slower than look up but sorted port
Join,well choosing of Master and detail configuration will
give better performance for Joiner.
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / 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 |
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
What is the difference between a table and the materialized view?
Explain the difference between a data warehouse and a data mart?
Quickly characterize reusable change?
What is status code in informatica?
How we can create indexes after completing the load process?
which transformation uses cache?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
Briefly explain the aggregator transformation?
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
Teradata 
