InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Date Track Concept In Oracle Hrms? |
|
Answer» Oracle HRMS has a date TRACK feature which enables to maintain past, present and future state of data. It enables to maintain the record HISTORY by creating a new record when the date track MODE is UPDATE and override on the existing record when the Data track mode is CORRECTION All date tracked tables end with _F. In data tracked tables, Oracle identifies the validity of record with ‘effective date’ columns (effective_start_date and effective_end_date) Oracle HRMS has a date track feature which enables to maintain past, present and future state of data. It enables to maintain the record history by creating a new record when the date track mode is UPDATE and override on the existing record when the Data track mode is CORRECTION All date tracked tables end with _F. In data tracked tables, Oracle identifies the validity of record with ‘effective date’ columns (effective_start_date and effective_end_date) |
|