DSXchange

Hi Doug.... The way to migrate the tables is via istool (export and then import)...the command line facility was updated in 8.1 FP 1 (and further in 8.1.2) to support the migration of Shared Table and their collections, and to provide the ability to import other wb artifacts such as Extension Mappin...

hmm... Two other thoughts to ask you to look at....

a) are you using formal "Connection Objects" in DataStage for your Oracle source and target?

b) are you also playing with Extension Mapping Documents?

Ernie

As noted before, starting with this much metadata can be very confusing. A table doesn't have to be related to "this" job to appear in the asset listing. It could be a table that is connected via 100 jobs prior to this one, in a lengthy sequence of lineage. For starters, take a close look ...

Excellent. Glad you got it working.

Do you have a simple java class working in the java transformer? What does the class do? did it ever work? how much memory does it need.....etc. etc. Lots of things to look for, but first ensure that you can get even a simple java class with the JavaPack API to function properly.

Ernie

Make sure you can open the document yourself using IE. Something is failing in its structure, or odd characters, or else maybe the way you are reading it via the External Source stage is an issue. I always use ls ...

Let's be sure and check a few things. Exactly what release of 8 are you on....? It would be best if you are at least on 8.1 with FP1 and 8.1.2 for MWB and BG loaded on top of that. Then we can look thru various things. I'd probably take away any Data Item Bindings or Database Alias settings or Stage...

Sounds to me like it is working wonderfully. This is one reason I suggest that you start your work with Metadata Workbench with a tiny set of related Jobs (maybe 3) that you are fully aware of and fully understand. Every possible connection that is made in your jobs, their shared containers, and the...

It's not entirely clear what problem you are having. A good thing to do is to first play with lineage within a single job, and only for Stages. Then you can get familiar with the behavior. Open Job 1 in the MWB....click on the target oracle "stage". Then select data lineage...where does th...

It's all "in the box" ...you need not buy anything...just some java experience......

Ernie

JavaPack may be your best bet....find a java developer who has read LDAP structures and show them how JavaPack works (search thru the forum here -- there lots of entries --- I also have some info and an example at www.dsrealtime.com ). They should find it very easy to integrate something into your D...

Check out the "Balanced Optimizer". This generates appropriate dialect specific SQL from a DataStage Job for doing "ELT"....

Ernie

The only tools I've heard of are those that aren't generically available, but used in conjunction with a services engagement .....one by IBM Lab Services and another by Compact BI, an IBM partner. Both have tooling that takes "other" transformation code and generates DataStage Jobs. I know...

Yes. DataStage has a capability called JavaPack...there are two Stages that can be used to invoke a Java class, and an API that lets you communicate (exchange data on input and output links, etc.) with the JavaClass. Do some searches here in the forum....there are lots of entries about "JavaPac...

From what I've seen, and in speaking with many of the sites who have been using the new XML Stage, it completely leap-frogs anything that any ETL tool has been doing with XML, bringing hierarchical management of xml documents for DataStage into the realm of what tools in the EAI space can typically ...