Explain what is data validation strategies for data mart validation after loading process?
What is defined as partial backup?
Briefly state different between data ware house & data mart?
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,
what are the types of dimension tables
Explain what are the tasks that loadmanger process will do?
What are the advantages of cold fusion?
Explain can report net connect multiple datasource at a time in report creation time?
How to export mappings to the production environment?
What is operational data source (ODS)?
What are loops in Datawarehousing?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
Explain what are the methodologies of data warehousing?