Types data elements and entities (Tables) for ETL.

It is important for an ETL developer to understand the types of tables and data, to intelligently design ETL processes. Once the common types objects are understood, reusable templates for ETL can be developed, regardless of business logic. This will greatly improve the efficiency of an ETL developer.

1. Reference data

2. Dimensional data (master data)

3. Transactional data

4. Transactions

5. Balances

6. Summary/Aggregations

7. Snapshots

8. Staging

9. Out triggers/mini dimensions

10. Log tables

11. Meta data tables

12. Security tables

13. Configuration tables


2 Responses to “Types data elements and entities (Tables) for ETL.”

  1. krishna.P says:

    how 2 explain unit testing

  2. krishna says:

    will you send me document about hoe to create a daily job to clean log files on BO servers

Leave a Reply