what is the logic will you implement to load data into a
fact table from n dimension tables?
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 IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
In any project how many mappings they will use(minimum)?
can we use bulk loading when we use look in mapping
How can we store previous session logs?
what is fact and what types of fact tables is there
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
without using emailtask how will send a mail from informatica?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
What are the differences between source qualifier and joiner transformation?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
What differs when we choose the sorted input for aggregator transformation?