what is the logic will you implement to load data into a
fact table from n dimension tables?
Answer Posted / satyaranjan
Always load data from dimension to fact is incremental load
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
what is diff b/t sorter t/r and agg have the option sorter property...
What are the differences between a connected lookup and unconnected lookup?
design of staging area?
Differentiate between sessions and batches?
What the difference is between a database, a data warehouse and a data mart?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Which development components of informatica have the highest usage?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How to do the error handling of if ur source is flatfiles?
Explain what transformation and how many are there in informatica?
Explain the code page compatibility?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What will be the approach?
Name the different lookup cache(s)?