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?
515Post New Data Warehouse General Questions
Explain what is partitioning? What are the types of partitioning?
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?
Explain multivalued dependency?
What are the different types of segments?
Explain a relation schema and a relation?
What is the difference between star and snowflake schemas?
Explain the versions of reportnet?
What are various warehousing tools?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What are the different methods of loading dimension tables?
Explain what is the limit to the number of sources and targets you can have in a mapping?
What are the various methods of getting incremental records or delta records from the source systems?
What is the very basic difference between data warehouse and operational databases?
What is is a star schema?
What is your spectra photometer working principles?