ETL TESTING

Replies to This Discussion

Permalink Reply by DILEEP KUMAR ANDHAVARAPU on February 28, 2011 at 2:19pm

ETL basically stands for Extract Transform Load - which simply implies the process where you extract data from Source Tables, transform them in to the desired format based on certain rules and finally load them onto Target tables. There are numerous tools that help you with ETL process - Informatica, Control-M being a few notable ones.

So ETL Testing implies - Testing this entire process using a tool or at table level with the help of test cases and Rules Mapping document.

In ETL Testing, the following are validated -
1) Data File loads from Source system on to Source Tables.
2) The ETL Job that is designed to extract data from Source tables and then move them to staging tables. (Transform process)
3) Data validation within the Staging tables to check all Mapping Rules / Transformation Rules are followed.
4) Data Validation within Target tables to ensure data is present in required format and there is no data loss from Source to Target tables.

• ▶ Reply

Permalink Reply by ASHOK A on January 13, 2012 at 1:54am

hi dilip thanqs for information could u plz tell me how we have to validate cubes,,

• ▶ Reply

Permalink Reply by Sanjay V on February 15, 2012 at 3:48pm

Hi  DILEEP,

Can u please let us know as to how we can Automate the ETL testing.

Thanks,
Sanjay 

• ▶ Reply

Permalink Reply by Dr M V Ananathakrishnan on February 28, 2011 at 2:32pm

http://en.wikipedia.org/wiki/Extract,_transform,_load

Pl view the above website

 

ALB

 

 

Dr Ananthakrishnan

TCS Retiree

• ▶ Reply

Permalink Reply by K.ANUSHA on August 12, 2011 at 11:46pm

Hello Mr. AnanthaKrishnan i m very very glad to meet you sir

thanks for your information regarding ETL . its really very needful to one who are searching for ETL testing.

Good posting sir

 

Thanks,

Anusha

• ▶ Reply

Permalink Reply by phaneendra Sagio on September 22, 2011 at 12:39pm

Please let me know which is the best institute for elt  in hyderabad. i need to learn ASAP.

 

Please help me out guys ..

 

phaneendra

9440967788

 

• ▶ Reply

Permalink Reply by ASHOK A on January 13, 2012 at 1:38am

I THINK THERE IS NO INISTITUTES IN HYD

• ▶ Reply

Permalink Reply by ASHOK A on January 13, 2012 at 1:43am

hello sir this is ashok i want to know how we hav to validate the cube? plz explain briefly

• ▶ Reply

Permalink Reply by ASHOK A on January 13, 2012 at 1:35am

IN ETL TESTING WE HAVE TO TEST END TO END VALIDATION...THE THING IS HERE IS TO MAITAIN QUALITY DATA IN DWH

• ▶ Reply

Permalink Reply by Santosh Kumar on January 22, 2012 at 10:12am

Hi Friends,

I am a Database Test Engineer and I would like to shift my base to ETL as it is related to database.

Can anyone help me out in this?

Also it would be helpful if anyone suggest any good institutions for the same in Hyderabad.

Thank you

• ▶ Reply

Permalink Reply by ASHOK A on January 31, 2012 at 2:30pm

Hi All

This is Ashok Teja i would like to say i am starting ETL TESTING Course in AMEERPET contact me<dwhashokalle@gmail.com><08149173089>...

Thanks..

 

 

• ▶ Reply

Permalink Reply by Santosh Kumar on February 26, 2012 at 12:52pm

What is the institute name?

• ▶ Reply

• ‹ Previous
• 1
• 2
• Next ›
• Page