There are 4 flat files with number of records as indicated below. Which files s

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,

Question Posted / curiousmind23

1 Answers
6935 Views
Amdocs, I also Faced
E-Mail Answers

There are 4 flat files with number of records as indicated below. Which files should be picked firs..

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

Post New Answer