ETL Testing

[G.Veeru]

Hi Guys,

I hope all are doing really well.

Staging area tables transform to Loading area in ETL. I am writing Test cases. Generally what r things consider to write test cases?
Not including business rules.

Based on my knowledge
1. Count the records
2. Data correct ness

Please help me thanks in advance.

[goodfellas]

Aslo u can write some GROP BY sql Queries... and search for duplicate records and so on...

[pktamanam]

1) No of records from source to target (Total number of source records = Total number of records in target + total number of records rejected)
2) Verify the rejected records (Need to verify these records are rejected as per the business logic or not)
3) In case if you have any summarised data then check total (amount fields) are summing up correctly when more records are rolled in to one records
4) check for duplicate records.
5) And any business constraints (Some case business rules will be like when PK fine then update SK in case SK is modified or find some other values in later arrived records in the staging area.