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

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,


wat are deployement groups in informatica, how it will be used for developers

0 Answers  


Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,


Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,


what is materialized view?

2 Answers  


any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  


How many number of sessions that u can create in a batch?

3 Answers  


What is a standalone command task?

0 Answers  


Define the various join types of joiner transformation?

0 Answers  


wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,


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

1 Answers  


How can you display only hidden files in UNIX

4 Answers   Cognizant, L&T,


Categories