InterviewSolution
| 1. |
What Are The Three Tables Of Ods Objects? Explain? |
|
Answer» ODS has three database TABLES. New Table, ACTIVE Table and CHANGE Log Table. Initially new data are loaded and their TRACES are kept in Change log table. When another set of data comes, it actually compares with change log and transfers the data (delta data) into active table and also NOTES in Change log. Every time the tables are compared and data is written into the targets. ODS has three database tables. New Table, Active Table and Change Log Table. Initially new data are loaded and their traces are kept in Change log table. When another set of data comes, it actually compares with change log and transfers the data (delta data) into active table and also notes in Change log. Every time the tables are compared and data is written into the targets. |
|