Datastage 8.0.1 optimnization
Posted: Tue Jul 07, 2009 4:34 am
Hi,
We have a requirement from the client to fine tune the jobs that are running for long time in production.
Environment details in brief:
Version : IBM WebSphere Datastage 8.0.1 (Sun OS 5.10)
Sources : Teradata,Oracle,Flat files Target : Teradata
Transformation rules : Complex
Nodes : 1 nodes in production ( config file)
From the observations, ETL tool, Datastage is only used when the business rules / functionality cannot be implemented using Teradata's SQL or via BTEQ.Loading is implemented through Datastage only with TD Multiload , TD Enterprise.
Please post your high points on the same which can help to fine tune the jobs.
Thanks, friend.kak@gmail.com
We have a requirement from the client to fine tune the jobs that are running for long time in production.
Environment details in brief:
Version : IBM WebSphere Datastage 8.0.1 (Sun OS 5.10)
Sources : Teradata,Oracle,Flat files Target : Teradata
Transformation rules : Complex
Nodes : 1 nodes in production ( config file)
From the observations, ETL tool, Datastage is only used when the business rules / functionality cannot be implemented using Teradata's SQL or via BTEQ.Loading is implemented through Datastage only with TD Multiload , TD Enterprise.
Please post your high points on the same which can help to fine tune the jobs.
Thanks, friend.kak@gmail.com