There are 4 flat files with number of records as indicated
below. Which files should be picked first for joining using
joiners so as to get best performance.
File A - 1000 records
File B - 100 records
File c - 10000 records
File D - 10 records
Please explain.
Thanks and Regards,
Answer / abhishek kumar
STEP:
1)FIRST JOIN FILE B AND FILE D HERE FILE D AS A MASTER AND
FILE B AS DETAIL.
2)THEN JOIN FILE A AS MASTER WITH OUTPUT OF STEP 1.
3)THEN JOIN FILE C AS MASTER WITH OUTPUT OF STEP 2
THIS THE RESULT.
IN JOINER
IF WE GO JOIN FOR TWO TABLE WE CHOOSE THAT TABLE AS A
MASTER WHICH CONTAIN MINIMUM RECORD OR LESS REPETION.
ACTUALLY COMPARE TO DETAIL , MASTER CACHE SIZE IS LESS.AND
OUTPUT RESULT WILL BE GO TO DETAIL
THANKS
ABHISHEK GUDDU
Is This Answer Correct ? | 9 Yes | 3 No |
How can we use mapping variables in informatica?
What is DTM process?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
"Change cache" in Informatica ?
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?
what is persistant cache in which situation we will use persistantcache
What differs when we choose the sorted input for aggregator transformation?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
Define joiner transformation?
How to do unit testing in informatica? How to load data in informatica ?
What are the disadvantages of Sequence Generator T/R?