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 |
Can we insert ,update ,delete in target tables with one update strategy tran.?
wat are deployement groups in informatica, how it will be used for developers
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
Where is the cache stored in informatica?
what is materialized view?
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
How many number of sessions that u can create in a batch?
What is a standalone command task?
Define the various join types of joiner transformation?
wht is full process of Information source to target just like stg to productuon and development
What is the Difference between PowerPlay transformer and power play reports?
How can you display only hidden files in UNIX