What are different stages of ?Data mining??
Explain why fact table is in normal form?
5.Explain ODS ?
What needs to be done when the database is shutdown?
how much memory space occupied real time project (roughly)?
Explain the definition of normalized and denormalized view?
How to performance tune reports?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
what type of raid setup would you put your tx logs?
What are aggregate tables and aggregate fact tables?
which automation tool is used in data warehouse testing?
What are the different types of segments?
Which component has onread method and what it is used for?