SCD Slowly changing dimension we are using for to load changing dimension information data.
where are three types of SCD'same
1) SCD TYPE1: No history, we will all columns SCD property as OVERWRITE ON CHANGE in ODI.
SCD TYPE1: we can use IKM Oracle Incremental update KM or we can IKM Slowly Changing Dimension both we can use.
2) SCD TYPE2: Here we can maintain no of times history, so we need to maintain below SCD properties in SCD TYPE 2 table.
1) ADD Row On CHANGE: this property will add a row whenever we are receiving changed data to maintain history.
2) STARTING_ TIME STAMP: This will show record starting date and time
3) Ending Time stamp: this will show record ending date and time
4) RECORD FLAG: this will show active record if it is Y and if it is N for old rows or history rows.
3) SCD TYPE 3: As of now ODI is not supporting we have to customise our IKM Slowly Changing Dimension. it will maintain only one time history in different column like , CURRENT SALARY and PREVIOUS SALARY two columns.
Posted Date:- 2021-10-08 04:02:56
What is the Master Repository?
How to write the procedures in ODI?
How to remove the duplicate in ODI?
How to write the subqueries in ODI?
What are the load plans and types of load plans?
How will you handle data quality in ODI?
How will you bring in files from remote locations?
How will you bring in the different source data into ODI?
Explain what is ODI? why is it different from the other ETL tools?
How to reverse engineer views(how to load the data from views)?
How to load the data with one flat file and one RDBMS table using joins?
How to implement data validations?
How to remove the duplicate in ODI?
How to write the sub-queries in ODI?
What are load plans and types of load plans?
Where does ODI sit with my existing OWB implementation(s)?
Does ODI support web services?
Where can I get more information on ODI?
Does my ODI infrastructure require an Oracle database?
What is Load Plan and different types of Load Plans?
How do ‘Contexts’ work in ODI?
What is Simulation option at interface?
What is Context and it's purpose?
What is an Agent and different types of Agents?
What is significant difference between Physical Schema and Logical Schema?
What is meant by OLAP and OLTP?
What is Repository and Types of Repositories?
What is the difference between ETL and ELT?
What systems can ODI extract and load data into?
What is Oracle Data Integration Suite?