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?
917Post New Data Warehouse General Questions
Give some difference between oltp and olap.
What is difference macros and prompts?
Why fact table is in a normal form?
Which component has onread method and what it is used for?
What is operational data store (ods)?
Explain what is the difference between powerplay transformer and power play reports?
In microstrategy, how can we direct the sql generated to use a specifc table?
Name a few sectors which use data warehousing?
What are data validation strategies for data mart validation after loading process?
What is partitioning? What are the types of partitioning?
Define Data Warehousing?
Explain what are slowly changing dimensions?
Where the applications and where ware house management system is used?
Explain what is the data type of the surrogate key?
Explain if a flat file cotains 1000 records how can I get first and last records only?