What is the difference between constraind base load ordering and target load plan?
What are the types of dimensional modeling?
Explain what are the different types of data warehousing?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
Why is business intelligence (bi) important in data warehousing?
Explain what is the difference between datawarehouse and bi?
Explain me what are data marts?
if you use oracle sql*loader , how do you transform data with it during loading?
What is VLDB?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
What are aggregate transformation?
What is core dimension?
Can any one explain the hierarchies level data warehousing.
What is metadata in context of a datawarehouse?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?