How you find which the latest record in SCD type2 transformation is?
- 1 Answers
- 683 Views
- Virtuas, I also Faced
- E-Mail Answers
Answer / Renu Sirohi
In Oracle Data Integrator (ODI), to find the latest record in a Slowly Changing Dimension Type 2 (SCD-Type 2) transformation, you can use the 'Version Column Strategy' during the mapping design phase. This strategy maintains two columns for each dimension key - an effective date column and an expiration date column. The latest record is represented by the null value in the expiration date column. Alternatively, you can query the target table to find the maximum effective date.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain for repository?
How many types of km's?
1 Answers Infosys, Tech Mahindra,
What are the constraints are used in Ur project?
How to send the emails for odi?
Can i create more than one Master Repository in ODI?
What is the load plans in odi?
What is odi studio?
Have you created fact table and dimension tables?
What is the data quality in odi?
Difference between ETL and E_LT?
What are the Types of Scd's?
Explain the designer?
Oracle General 
