what is the logic will you implement to load data into a
fact table from n dimension tables?
- 4 Answers
- 18927 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ranjeet
does this question have any sense, I don't think so
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / satyaranjan
Always load data from dimension to fact is incremental load
| Is This Answer Correct ? | 6 Yes | 2 No |
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 are the different types of transformation available in informatica and what are the mostly used ?
What is critical mapping?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
What are different types of transformations available in informatica?
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
design of staging area?
How to load data in informatica ?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
how to duplicates from expression transformation without using sorter before that
How do you load unique records into one target table and duplicate records into a different target table?
What are active transformations.
Limitation of REPLACESTR. Is there any character limitation to it.
Teradata 
