what is data validation strategies for data mart validation
after loading process
Answer / 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 |
What are the types of partitioning?
what is query optimizer? what are different types of optimizer s supported by oracle ?
Database in use is oracle?
how do you use commit frequencies? how does it affect loading performance?
In microstrategy, how can we direct the sql generated to use a specifc table?
What is a fact table?
2.What is staging area ?
4 Answers HCL, IBM, iFlex, TCS,
What is XMLA ?
What is fact less fact table? Where you have used it in your project?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What is critical column?
what is the difference between aggregate table and fact table ? how do you load these two tables ?