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 decode in informatica?
in which situations do u go for starflake schema ?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
What is a joiner transformation?
How big was your fact table
what is the difference between repository & Intergration service
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
generate date / time dimension in informatica
Explain the tuning lookup transformation - informatica
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
what is left outer join?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.