Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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,



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

More Informatica Interview Questions

What is Cognos script editor?

0 Answers   Cognizant,


What are the different types of repositories created using informatica?

0 Answers  


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.

0 Answers   Informatica,


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).

1 Answers   CTS,


Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,


hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 Answers  


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  


What is IQD file?

1 Answers  


What is the Difference between PowerPlay transformer and power play reports?

1 Answers  


Can you start a session inside a batch individually?

2 Answers  


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

0 Answers  


By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,


Categories