what are different ways of loading data to data warehouse
using oracle?
What is data merging, data cleansing and sampling?
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.
Explain what are the tasks that loadmanger process will do?
Explain me what are data marts?
How can we run the graph? What is the procedure for that?
What are aggregate fact tables ? why they are needed? give an example
How to load the time dimension?
Start a batches with in a batch?
What is metadata in context of a datawarehouse?
Tell me what is degree of a relation?
Explain dimensional modelling?
What are the various transformation available?