What is the main difference between inmon and kimball philosophies of data warehousing?
Explain what are non-additive facts?
What is operational data store (ods)?
Explain the difference between view and materialized view?
What is the advantages data mining over traditional approaches?
What is partitioning? What are the types of partitioning?
How to pivot row data using informatica?
How to eliminate duplicate rows from flat file?
Explain the hierarchies level data warehousing.
What are the differences between star and snowflake schema?
Explain what are necessary tasks to install reportnet software?
What is difference macros and prompts?
What is load manager?
What needs to be done while starting the database?
Explain the difference between oltp and olap?