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
- 19820 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
what is index?how it can work in informatica
Explain the aggregator transformation?
How might you approve all mappings in the archive all the while?
Which is the t/r that builts only single cache memory?
What are the limitations of joiner transformation?
What is meant by query override?
what is the hint? how to use it to reduce the query processing in program?
What is repository manager?
What is persistent lookup cache?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What do think which one is the better joiner or look up?
pmscmd startworkflow -sv
What is the difference between stop and abort in informatica
