Explain what are the various methods of getting incremental records or delta records from the source systems?
What is Star Schema?
What are data validation strategies for data mart validation after loading process?
Explain conformed fact?
What are the various transformation available?
What are the key columns in Fact and dimension tables?
How can we schedule the graph in unix?
What are the advantages of raid 1, 1/0, and
I need to set predefined condition. How I do this?
Explain why dimenstion tables are denormalized in nature?
What is data warehosuing hierarchy?
What is the metadata extension?
What is is a star schema?
What are snapshots? What are materialized views & where do we use them?
what are the others of "bad files" and "discard files" when using sql*loader?
