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?
526How 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?
543Post New Data Warehouse General Questions
What are the approaches used by optimizer during execution plan?
What are the different types of scd's used in data warehousing?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What is vdl (view definition language) explain?
What are Non-additive facts?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Briefly state different between data ware house & data mart?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What are data validation strategies for data mart validation after loading process?
Explain the structure of cold fusion?
if you use oracle sql*loader , how do you transform data with it during loading?
What is a real-time data warehouse?
Define Data Warehousing?
Explain what are data marts?