Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
524How 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?
541Post New Data Warehouse General Questions
What is a full backup?
Is there any difference in testing database and data ware housing?
What is surrogate key? Where we use it?
What is Analysis Services?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
Explain what are slowly changing dimensions?
Why fact table is in a normal form?
What is the difference between drill through and masterdetail reports?
Explain what are the possible data marts in retail sales?
Explain differences between star and snowflake schemas?
Explain how to get the first 100 rows from the flat file into the target?
What is Discrete and Continuous data in Data mining world?
How to design file watch jobs?
What are the various methods of getting incremental records or delta records from the source systems?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?