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
- 7522 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
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is a grid in Informatica?
How we can create indexes after completing the load process?
What is sq transformation?
Global and Local shortcuts. Advantages.
Write the prerequisite tasks to achieve the session partition?
What is native users?
Enlist the advantages of informatica.
What is union transformation in informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
What does “tail –f” command do and what is its use as an Informatica admin.
What is workflow monitor?
How are indexes created after completing the load process?
What is the maplet?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
