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

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

Question Posted / guest

4 Answers
19756 Views
TCS, I also Faced
E-Mail Answers

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