what is the logic will you implement to load data into a
fact table from n dimension tables?
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
What is the Rank index port in Rank transformation?
can you please explain me pre session and post session options?
What is option by which we can run all the sessions in a batch simultaneously?
What are the new features of Power Center 5.0?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the performance considerations when working with aggregator transformation?
How many numbers of sessions can one group in batches?
How do you set a varible in incremental aggregation
How many dimensions are there in informatica?
What is intricate mapping?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is informatica powercenter repository?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
difference between informatica 8.1.1 and 8.6
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?