- History Preserving is for providing new row in the target instead of updating the existing row.
- The columns are indicated for transforming the changes that are to be preserved.
- New rows are created when the value of certain column changes.
- Each of these rows is flagged as UPDATE.
- The UPDATE flag is applied for the input data set.
Please explain in detail about type 1, type 2(SCD), type 3?
Explain what is aggregate table and aggregate fact table ... any examples of both?
Explain What is fact less fact table? where you have used it in your project?
Explain me what kind of costs are involved in Data Marting?
Tell us out of star schema and snowflake schema, whose dimension table is normalized?
Tell us what is Virtual Warehouse?
Tell us what does the Query Manager responsible for?
Can you list the Schema that a data warehouse system can implements?
Tell us what is the main difference between Inmon and Kimball philosophies of data warehousing?
Tell us what is Hybrid SCD?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
