Interested to Buy Any Domain ? << Click Here >> for more details...
what is the logic will you implement to load data into a
fact table from n dimension tables?
- 4 Answers
- 19844 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
explan ur project architecture?
What is Cognos script editor?
waht type of interface is used for testing the data in informatica
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the sql query overwrite in source qualifier in informatica
What is source qualifier transformation in informatica?
How to go to the older version for a mapping?
What are the different transaction levels available in transaction control transformation?
What is a repository? And how to add it in an informatica client?
What does role playing dimension mean?
What are the types of data warehouses?
Name the different lookup cache(s)?
What is native users?
Implementation methodology
Suppose we do not group by on any ports of the aggregator what will be the output?
