InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are Setup Tables And Why Should We Delete The Setup Tables First Before Extraction? |
|
Answer» Setup tables are filled with data from application tables. They are the OLTP tables STORING transaction record. They interface between the application tables and EXTRACTOR. LO extractor takes data from Setup table while initialization and full upload. It is not needed to access the application table for data SELECTION. As setup tables are required only for full and init load we can delete the data after loading in order to AVOID duplicate data. Setup tables are filled with data from application tables. They are the OLTP tables storing transaction record. They interface between the application tables and extractor. LO extractor takes data from Setup table while initialization and full upload. It is not needed to access the application table for data selection. As setup tables are required only for full and init load we can delete the data after loading in order to avoid duplicate data. |
|