what is data validation strategies for data mart validation
after loading process
Answer Posted / idris
direct(faster)
loads data first then validates with keys and avoids
records without reference while indexing
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How can you set the session management?
How to handle multi value dimensions?
Explain which are the olap tools available that are supported by oracle?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
Explain the differences between normalizer and normalizer transformation?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What are the difference between snow flake and star schema?
What is the difference between view materialized view and view?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What are the different types of datawarehosuing?
what is difference between drill & scope of analysis?
What is a fact, dimension, measure?
What are the various transformation available?
What needs to be done when the database is shutdown?