| || |
ETL Testing Automaion
i need a smart solution for my ETL Testing ..
data is transforming from Source database (oracle) to Target XML file or flat file, by INFORMATICA ETL workflows..there are some business RUles for the data mapping from source to target which are data mapping rules..i need to validate and test the Target data after ETL runs from source database to Target file ..
Pls suggest an effective automation solution OR any good solution..
Re: ETL Testing Automaion
Why don't you simply transform a selection of the data containing known variations, and then verify that the converted data are exactly what you then expect from the ETL transform. I think you try to make a more complex problem out of a simple task.