Why is dimensional normalization not required?
Explain what is real time data-warehousing?
What is scd1 , scd2 , scd3?
Is it possible to have more than one row on the same table with the same foreign key?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
What are aggregate tables and aggregate fact tables?
For faster process, what we will do with the universe?
Explain what is the limit to the number of sources and targets you can have in a mapping?
What are the advantages of raid 1, 1/0, and
Tell me one example for multi valued dimension or bridge table?
2 Answers Accenture, CMC, IBM, Logica CMG, TCS,
How can you import tables from a database?
Explain what are the vaious etl tools in the market?
Explain how many ways you create ports?