Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
962Post New Data Warehouse General Questions
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?
What is aggregate fact table?
What are the approaches used by optimizer during execution plan?
List down some of the real time data-warehousing tools?
What do you mean by static and local variable?
Explain can report net connect multiple datasource at a time in report creation time?
What is normalization, first normal form, second normal form, third normal form?
Where we use surrogate key explain with example?
Explain er diagram?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is incremintal loading?
What are session timeout and application timeout? Where we have to do this process?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
What is metadata in context of a datawarehouse and how it is important?
What are the data types present in bo? What happens if we implement view in the designer n report?