Interested to Buy Any Domain ? << Click Here >> for more details...
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,
- 1 Answers
- 7617 Views
- Amdocs, I also Faced
- E-Mail Answers
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 |
What are the diffrences between joiner transformation and source qualifier transformation?
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
What is the use of incremental aggregation?
What is the procedure to load the fact table.Give in detail?
I have source like this 1:2;3. so i want to load the target as 123
why dimenstion tables are denormalized in nature ?
where to select code page option?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
Is it possible to have "5 source & 5 Target" in single mapping?
How you know when to use a static cache and dynamic cache in lookup transformation?
Quickly characterize reusable change?
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
Teradata 
