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
What is surrogate key? Explain with examples.
Define data warehouse?
What are the difference between snow flake and star schema?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What a static and local variable?
What is called data cleaning?
What is the difference between static cache and dynamic cache?
What is Star Schema?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What are components of reportnet?
Name a few sectors which use data warehousing?
Explain what is full load & incremental or refresh load?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?