How to find Repository Objects

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mujeebur
Participant
Posts: 46
Joined: Sun Mar 06, 2005 3:02 pm
Location: Philly,USA

How to find Repository Objects

Post by mujeebur »

Hi,

How to find Repository Objects in DataStage ? Like in Informatica there is a Informatica Repository Database , in which all the repository database tables will be located .
sachinkc
Participant
Posts: 34
Joined: Sat Apr 17, 2004 11:39 am
Location: USA

Re: How to find Repository Objects

Post by sachinkc »

There is one in DataStage too going by the name of Universe (another IBM product).

If you are new, better start by using DataStage Administrator to access it, instead of uv console commands. Its documentation can help you get started.

- Sachin
mujeebur wrote:Hi,

How to find Repository Objects in DataStage ? Like in Informatica there is a Informatica Repository Database , in which all the repository database tables will be located .
Rgrds & Cheers!

Sachin
sachin@operamail.com
~Life always finds a way~
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

In the current release the DataStage repository is closed; that is, its table definitions are not in the public domain.

The Reporting Assistant can dump information from the DataStage repository into a first-normal-form, with your choice of target database.

Within DataStage, the repository makes a lot of use of multi-valued fields for storing collections of object properties, and it is bewildering for anyone brought up in a first-normal-form way of thinking. Therefore, Ascential choose not to reveal much about how things are stored in the DataStage Repository.

This situation (non-open repository database) may change in an upcoming release, but I never told you that. :wink:
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply