G.Veeru Posted July 28, 2011 Report Share Posted July 28, 2011 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 knowledge1. Count the records2. Data correct nessPlease help me thanks in advance. Quote Link to comment Share on other sites More sharing options...
goodfellas Posted July 28, 2011 Report Share Posted July 28, 2011 Aslo u can write some GROP BY sql Queries... and search for duplicate records and so on... Quote Link to comment Share on other sites More sharing options...
pktamanam Posted July 28, 2011 Report Share Posted July 28, 2011 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 records4) 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.