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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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,

Question Posted / abhishek kumar

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


Please Help Members By Posting Answers For Below Questions

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2073

How to start a workflow using pmcmd command?

1245

Explain the types of transformations?

1061

What are active transformations.

1650

How to elaborate powercenter integration service?

1129

What is meant by a domain?

1122

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1080

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2129

What is the format of informatica objects in a repository?

1017

How do we call shell scripts from informatica?

1108

Design a mapping to load a target table with the following values from the above source?

1341

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2452

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1161

Briefly describe lookup transformation?

1044

where to store informatica rejected data?

1093