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

what is the logic will you implement to load data into a
fact table from n dimension tables?

Question Posted / guest

Answers were Sorted based on User's Feedback



what is the logic will you implement to load data into a fact table from n dimension tables?..

Answer / ranjeet

does this question have any sense, I don't think so

Is This Answer Correct ?    9 Yes 3 No

what is the logic will you implement to load data into a fact table from n dimension tables?..

Answer / satyaranjan

Always load data from dimension to fact is incremental load

Is This Answer Correct ?    6 Yes 2 No

what is the logic will you implement to load data into a fact table from n dimension tables?..

Answer / vikaskrmails@gmail.com

fist of all, Fact and Dimensions are separate entity tables
because fact contains measures and PK and FK where as Dim
contains Detail data along with PK and FK.
Dimensions and fact's loaded by their different sources
first we load dimensions and simultaneously assigned it to
surrogate key by sequence or CSUM etc functions. dimension
can maintain FK for other related dimensions and facts.
after loading fact we are updating it with Dim's PK-FK by
lookup.

Is This Answer Correct ?    4 Yes 2 No

what is the logic will you implement to load data into a fact table from n dimension tables?..

Answer / elango

fact table should contain all foreign key (PK) of the
dimensional tables, and it should be measured based on the
measures in the fact table as per the client specification.

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More Informatica Interview Questions

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

What are the basic needs to join two sources in a source qualifier?

3 Answers  

What are the different threads in DTM process?

2 Answers  

What is power play plug in?

2 Answers  

Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

list out all the transformations which use cache?

0 Answers   Informatica,

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

For more Informatica Interview Questions Click Here
Categories