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 |
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Where is metadata stored?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
How will u find weather dimension table is big in size of a fact table?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
how to connect two or more table with single source qualifier?
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
What are the types of caches in lookup?
Explain sessions and how many types of sessions are there?