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
- 19794 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 |
Different sorts of metadata that stores in the storage facility?
Performance tuning( what you did in performance tuning)
Whats there in global repository
How to handle changing source file counts in a mapping?
what is the look up transformation?
What are the tasks that can be performed using sq?
Can we run session without using workflows?
How to extract the informatica rejected data?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
whether Sequence generater T/r uses Caches? then what type of Cache it is
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
What is a parameter When and where do you them when does the value will be created
Teradata 
