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? Where we use it?
What are data modeling and data mining?
Explain a mapping, session, worklet, workflow, mapplet?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is meant by metadata in context of a data warehouse and how it is important?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
What are session timeout and application timeout?
What is defined as partial backup?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What is the goal of optimizer?
After the complete generation of a report who will test the report and who will analyze it?
What is a data warehousing?
What are the mapping paramaters and maping variables?
Explain what are the vaious etl tools in the market?