What are the characteristics of data after ETL?
What will be an ideal response?
The goal of ETL is to provide a single, authoritative source for data that support decision making. Ideally, the data layer will have the following characteristics:
1. Detailed, providing maximum flexibility
2. Historical
3. Normalized—fully normalized to third normal form
4. Comprehensive
5. Timely
6. Quality controlled
You might also like to view...
Which of the following is a function of an IT service firm?
A) Run applications for customers B) Support an order entry system C) Rent licenses D) Provide open source software
Which feature below would not be considered a highly convenient feature for consumers of an Internet store transaction?
A) Consumers usually must wait for delivery of items purchased via delivery by third parties. B) Internet store transactions can be completed without any human intervention on the part of the vendor. C) Internet stores are "open" 24 × 7 with virtually worldwide access. D) Internet stores accept most credit cards.