pvsbandi
asked on
How to do ETL Testing?
Hi Friends,
I've been a BO developer all my career and now got an opportunity to do some ETL Testing on the Informatica and Datastage Mappings.Basically, the data is extracted from Oracle and some flat files and then would have some transformations in between and finally, the data would be loaded into the DB2 database.
I haven't done Testing before.So, i'm wondering how the testing between multiple databases/flat files feasible?
Any valuable inputs from you experts are highly appreciated.
Thanks much!
I've been a BO developer all my career and now got an opportunity to do some ETL Testing on the Informatica and Datastage Mappings.Basically, the data is extracted from Oracle and some flat files and then would have some transformations in between and finally, the data would be loaded into the DB2 database.
I haven't done Testing before.So, i'm wondering how the testing between multiple databases/flat files feasible?
Any valuable inputs from you experts are highly appreciated.
Thanks much!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> I don't have the privilege to tweak the mappings
Sorry If my words meant that to you..
I mentioned to tweak your data in Oracle Source and check whether your logic ignores that particular record or not for processing.
Sorry If my words meant that to you..
I mentioned to tweak your data in Oracle Source and check whether your logic ignores that particular record or not for processing.
ASKER
Oh, ok.I understand what you are saying. That's a very nice tip!
Thanks much!
Thanks much!
Welcome..
And glad to help you out..
And glad to help you out..
ASKER