ETL Tester /DatawarehouseQA/DWT QA

ETL Tester /DatawarehouseQA/DWT QA

Instantly Turn your Computer into a Super TV. Enjoy iPod, PSP, IPhone, Movies, Music, MP3, TV Shows! - http://cbnk.biz/HLSTV364773RYRRGDK

Send SMS to India @ 1 Cent / SMS! Packs Start $2 Only - http://cbnk.biz/HL1CS364773RYRRGDK

Register (any name) .com website for 1 Year @ Rs.365 Only! Hurry! - http://cbnk.biz/HLDOM364773RYRRGDK

Win cash Rs.10,000. SMS BLUFF to 57333 (India Only) Free registration! - http://cbnk.biz/HLDDT364773RYRRGDK

ETL Testing with informatica and oracle

ETL should not be confused with a data creation process. It never creates new data. If a list of hundred employees is being loaded, one more employee cannot be added to the list and make it hundred and one. Or if last name of customer is absent an arbitrary last name cannot be substituted. Data warehouses are not OLTP systems. Duplication of calculations in Source system & the data warehouse should not be attempted, as the numbers will be very difficult to match during QA. Also in future the process in the source system can change that will result in asynchronous data. ETL cannot change the meaning of data. For example for sex ‘M’ and ‘F’ in source system sex flag to ‘1’ and ‘2’ is used in the Data Warehouse respectively. This is OK because this does not change the business meaning of the data. It only has changed the representation of the data. What is ETL?Extract, transform and load (ETL) software, which includes reading data from its source, cleaning it up and formatting it uniformly, and then writing it to the target repository to be exploited.what is Purpose of ETL ? After extraction, the data is transformed, or modified, depending on the specific business logic involved so that it can be sent to the target repository. There are a variety of ways to perform the transformation, and the work involved varies. The data may require reformatting only, but most ETL operations also involve cleansing the data to remove duplicates and enforce consistency. Part of what the software does is examine individual data fields and apply rules to consistently convert the contents to the form required by the target repository or application.