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?
What is data warehouse architecture?
What is DTM session?
What are the types of dimensional modeling?
How much data hold in one universe.
What are the data marts?
How can Oracle Materialized Views be used to speed up data warehouse queries?
What is the difference between drill through and masterdetail reports?
Explain what are the various methods of getting incremental records or delta records from the source systems?
how do you use commit frequencies? how does it affect loading performance?
What is latest version of power center / power mart?
I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE
What are the steps involved in designing a fact table?