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

how the data will be loaded while desiging the schema?which
one first (for e.g.-dimesions and facts)

Question Posted / gharish.inf

Answers were Sorted based on User's Feedback



how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and fact..

Answer / sree

dimension tables are loaded first and fact tables.As all primary keys of the dimension table is linked with the foreign keys of fact table for proper lookup we need to load dimension tables first.

Is This Answer Correct ?    7 Yes 0 No

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and fact..

Answer / suraj kedia

The order of loading the schema is as below:

1)Dimension Table
2)fact table

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,

what is song in infrmatica...?

0 Answers   CTS,

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  

What is Session and Batches?

0 Answers   Informatica,

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

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

3 Answers  

how we load the data from source to staging area

4 Answers   TCS,

What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,

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

1 Answers   Informatica,

I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

For more Informatica Interview Questions Click Here
Categories