Link to home
Start Free TrialLog in
Avatar of pvsbandi
pvsbandiFlag for United States of America

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!
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pvsbandi

ASKER

Thanks! I don't have the privilege to tweak the mappings.I can only validate the changes from source to target.
>> 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.
Oh, ok.I understand what you are saying. That's a very nice tip!

Thanks much!
Welcome..
And glad to help you out..