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 |
What is Cognos script editor?
What are the different types of repositories created using informatica?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
Performance tuning in UNIX for informatica mappings?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is IQD file?
What is the Difference between PowerPlay transformer and power play reports?
Can you start a session inside a batch individually?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?