ETL -DW Testing

ETL -DW Testing

Postby srisa » Fri May 04, 2012 3:01 pm

what is data standardization?
Is testing the Report tools like (cognos, Business objects) same as ETL testing or different?. If it is different how it is different?
Posts: 1
Joined: Thu May 03, 2012 7:12 pm

Re: ETL -DW Testing

Postby deepthi12 » Wed Mar 12, 2014 5:54 pm

Generally ETL stands for extraction,transformation and loading
In each stage of these we need to test it
the data flows from source - statging- target - DW- reporting ( depends on the project )
for all these stages we need to test the source to target doing data validation(any duplicates , counts,...) as data is pulled from different sources and integrated
Report testing is the front end application where we need to test report layout , alignment, filtered conditions, type of report ,
An this Cognos is one reporting tool in which we can pull the data from db and create reports in the report net studio of the cognos.

In my view data standardization means as the data coming from different each have different format for our convenience we keep data standardized in one of our source .
Posts: 8
Joined: Fri Mar 07, 2014 7:07 am

Return to ETL - Data warehousing Testing

Who is online

Users browsing this forum: No registered users and 1 guest