How you find which is the latest record in SCD type2 transformation?
- 1 Answers
- 685 Views
- Virtuas, I also Faced
- E-Mail Answers
Answer / Gaurav Aggarwal
In an SCD Type 2 transformation in Oracle Data Integrator (ODI), you can find the latest record by using the 'Current Date' function or a sequence in your query. The 'Current Date' function will return the current date, and you can use it to identify the most recent record based on a timestamp column. A sequence can also be used to generate unique numbers for each insert operation.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is J2EE Agent and port number?
How you find which is the latest record in SCD type2 transformation?
Have you attend the client meetings?
Does my odi infrastructure require an oracle database?
What is a user function?
What are the types of profiles in ODI?
In topology manager where the data are stored?
how to write the sub-queries in odi?
1 Answers Hexaware, Seventhsense Technologies,
explain what is odi?why is it different from the other etl tools.
What are the types of data contol?
What are the constraints are used in Ur project?
What are the Types of repositories in ODI?
Oracle General 
