Define data warehouse?
No Answer is Posted For this Question
Be the First to Post Answer
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
Briefly state different between data ware house & data mart?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
Explain in detail abt measure objects? And what is the use of it? How to create it?
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?
How to performance tune reports?
How can we transform row to column?
Explain the definition of normalized and denormalized view and what are the differences between them?
How to import vsam files from source to target. Do we need a special plugin?
What is a look up function? What is default transformation for the look up function?
Explain bus schema?
What are the tools available for etl?