Hello folks,
This is a open thread to list out some of the DataStage features, we feel like lacking in the currently available versions. Please share your knowledge if you feel some of the features listed are already available [or there is an alternative approach] :-
your contributions/suggestions are very welcome :-
Features "looking forward"
================
1)Jobs in Designer should have a last run parameter view , where it should automatically pick up the last run parameter. this is helpful when debugging [especially complex jobs]. example: view data should automatically fill in the last run parameters.
2)Custom aggregates [as supported in Oracle ODCIAggregate, lack of this in an ETL tool is very surprising].
oracle custom aggregates
3)External metadata for the repository which can be organized in 3rd party databases like oracle. [Informative is great in this extent]
4) Performance statistics of how much time the job is spending on each stage, how much memory is used, IO time etc
5)Unconnected lookups. Meaning if the lookup of a source row gives more than 1 row. it should pass on both the rows instead of 1. [i can understand "one row at a time" is the basis of datastage. At least it makes sense to pass 2 rows in case of a lookup]
Cool Features
========
1)Same "Look and Feel" in all the components Designer, Manager and Director.
2)Copy paste of stages , links , what not
3) Find and replace in transformer[ even though, no shortcuts like CTR+F , i know of]
4)regular expression
..
..
..
top of my head
regards,
Prabu
Open -> "Good to have" Features in DataStage ne
Moderators: chulett, rschirm, roy
Open -> "Good to have" Features in DataStage ne
Last edited by prabu on Mon Aug 14, 2006 8:27 am, edited 1 time in total.
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Re: Open -> "Good to have" Features in DataStag
Agree, I had to write one of these in BASIC code so when a job started it saved parameter to a file and when it restarted it loaded from that file.prabu wrote:Hello folks,
Features "looking forward"
================
1)Jobs in Designer should have a last run parameter view , where it should automatically pick up the last run parameter. this is helpful when debugging [especially complex jobs]. example: view data should automatically fill in the last run parameters.
And while you are at it how about a parallel aggregation stage that can sum and count at the same time! (Cannot currently do this, the count function excludes all other functions).prabu wrote:2)Custom aggregates [as supported in Oracle ODCIAggregate, lack of this in an ETL tool is very surprising].
oracle custom aggregates
Done, this is in the Hawk release. A metadata repository on Oracle/SQL server/DB2 or Sybase and SOA metadata backbone.prabu wrote:3)External metadata for the repository which can be organized in 3rd party databases like oracle. [Informative is great in this extent]
Available for parallel jobs. Improved in Hawk with extra monitoring tools.prabu wrote: 4) Performance statistics of how much time the job is spending on each stage, how much memory is used, IO time etc
Available in parallel jobs.prabu wrote: 5)Unconnected lookups. Meaning if the lookup of a source row gives more than 1 row. it should pass on both the rows instead of 1. [i can understand "one row at a time" is the basis of datastage. At least it makes sense to pass 2 rows in case of a lookup]
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
Re: Open -> "Good to have" Features in DataStag
And Server jobs using the ODBC or UV stages.vmcburney wrote:Available in parallel jobs.prabu wrote: 5)Unconnected lookups. Meaning if the lookup of a source row gives more than 1 row. it should pass on both the rows instead of 1. [i can understand "one row at a time" is the basis of datastage. At least it makes sense to pass 2 rows in case of a lookup]
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers