Interested to Buy Any Domain ? << Click Here >> for more details...
Why should we use data ware housing and how can you extract data for analysis with example?
TCS,
1044Post New Data Warehouse General Questions
Explain what is batch and describe about types of batches?
Explain hybrid slowly changing dimension?
What needs to be done when the database is shutdown?
I have two universes created by two difference database can we join them in designer & report level? How
What is "method/1"?
What are the main steps to build the data warehouse?
What are the different types of schemas used in data warehousing?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
what are the others of "bad files" and "discard files" when using sql*loader?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
How are the dimension tables designed?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Describe a data warehouse.
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
Explain what are conformed dimensions?
