National Operator_​New

Lookup Tables: Source

Derived from Revenue_Common.Xlm

Lookup Tables: Source

Derived from Pooling Table_A2B

Lookup Tables: Source

Excel Import- Dimention Table, Pooling Tables & Driver Table:
Since Tables are big so imported the relevant parts

Input Stage: Transformations are very simple to troubleshoot at this stage

• Files are imported here- Base files are Billing, VAA & Mapping File from Project Owners

• Lookup Tables: Created using Revenue.xlm File

  • Transformation done during the import rather post import like in current project

Process Billing Stage

1. Transformation at this stages works input for next stage

2. ETL are simple at this stage to make Trobuleshoting easy

ATTRIBUTE to ABM

1. Transformation at this stages works input for next stage

2. ETL are simple at this stage to make Trobuleshoting easy

Assignment B to H

1. Transformation at this stages works input for next stage

2. ETL are simple at this stage to make Trobuleshoting easy

ATTRIBUTE TO ACCOUNT

1. Transformation at this stages works input for next stage

2. ETL are simple at this stage to make Trobuleshoting easy