What is the procedure to load the fact table.Give in
detail?
Answer Posted / dr.journalist
Fact table basically consists of Foreign keys which are
taken from the primary keys of all dimension as well as
facts.
So, for this reason take all the dimensions as Unconnected
lookups and try to take the foreign keys and at the same
time try to use the avaialble sources and make all possible
facts with the necessary transformations.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
How to go to the older version for a mapping?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Enlist some properties of sessions.
What do you mean incremental aggregation?
Write the different tools in the workflow manager?
What are the guidelines to be followed while using union transformation?
What is workflow? What are the components of the workflow manager?
can u give example for factless fact table
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are the types of schemas we have in data warehouse.
What do you understand by a term domain?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Differentiate between reusable transformation and mapplet.
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the types of presistent cache in look up tr.