HI Guys,
I come from an ETI background, One of my client would like to migrate to Datastage. I would need some help in assessing, what are the points we need to conver to move the existing ETI conversions to DataStage. The current ETI conversion jobs are running on Mainframe.
If you guys could help with your ideas it will be really great.
How to move from ETI *EXtract to Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
You need to decide whether you want to leave the processing on the mainframe:
- use DataStage 390 jobs that compile into cobol code for mainframe execution
- pull the data off the mainframe and process it on the ETL server as server jobs or parallel jobs
There is no way to automate the migration from ETI to DataStage, you will be building the DataStage jobs from scratch (with all the advantages of shared containers, routines and table definitions to speed things up). What you need from ETI is a way to show the data lineage in each job and the transformation rules. This means going back to the documentation of the jobs (if it exists) or generating documentation out of the ETI repository or screen shots of ETI jobs.
- use DataStage 390 jobs that compile into cobol code for mainframe execution
- pull the data off the mainframe and process it on the ETL server as server jobs or parallel jobs
There is no way to automate the migration from ETI to DataStage, you will be building the DataStage jobs from scratch (with all the advantages of shared containers, routines and table definitions to speed things up). What you need from ETI is a way to show the data lineage in each job and the transformation rules. This means going back to the documentation of the jobs (if it exists) or generating documentation out of the ETI repository or screen shots of ETI jobs.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Premium Member
- Posts: 70
- Joined: Thu Aug 14, 2003 6:24 am
- Contact:
Before all, you need to make a decision where you want to store your data( what DB and which OS). You need to choose appropriate products like DS390 and/or parallel extender(depends on servers and load size). look into accelerators and DSL used in ETI and the most important how you want to mange your metadata. MetaStage will tightly integrate with Datastage to solve that.
Sree
Sree