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
- 7623 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the different ways to implement parallel processing in informatica?
What is the reusable transformation?
How to handle decimal places while importing a flatfile into informatica?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is a standalone command task?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain the different kinds of facts.
lookup transformation with screenshots
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How to join three sources using joiner? Explain though mapping flow.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is option by which we can run all the sessions in a batch simultaneously?
Slowly changing dimensions, types and where will you use them
What is a shortcut and copy in Informatica and how two are different with each other?
