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
- 19683 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
Tell me about Propagate functions in informatica
Performance tuning( what you did in performance tuning)
What is meant by incremental aggregation?
Difference between Data and Index Caches?
What is the function of look up transformation?
What is the surrogate key?
generate date / time dimension in informatica
What is an expression transformation?
What are the informatica performance improvement tips
Can we create a node as a gateway node and the same node can be assigned to a grid?
What does cheating measurement mean?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How to create or import flat file definition in to the warehouse designer?
Define sessions in informatica etl?
How many number of sessions can one group in batches?
