veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Jul 20th, 2009

 

DataStage jobs are classified into 3 types

1.Server job
2.Parallel job
3.Mainframe job

3 types are designed for to do the ETL process. difference among them is

Server job: execures sequentiall like row by row execution. as per performence wice it takes more time than px job to complete the excution.

PX Job: excutes paralally and it supports pipeline and datapartition techniques to complete the execution very quickly compare to server job

Mainframe job: mainframe job specifically desined for to read and excute the cobol data.