DSXchange

Thanks a lot for the very clear and crisp answer.
A term can move from pending approval to draft i.e rejected with comments. This is a great feature which business would most likely want to use.

Starting with Erwin 8 , CA has come up with a dedicated bridge to import models directly from erwin to IBM infosphere. There are 3 bridges provided by CA one for importing to Datastage and another one to IBM metadata workbench. I do not remember the third one.

Regards
Sreeni

Hi all, Back to the forum after 1 yr :) We are in the process of rolling out BG to our data management group. There are two sets of workflow 1st set - standard stage and then accepeted staged 2nd set - this i undersdand. pending approval and then published Can you please let me know the difference i...

Try Using the reject links in LOOKUP, MERGE stage

Datastage in test and dev are not in sync

Regards
Sreeni

coalesce takes the first notnull out of the input set of values. I think he is asking that sort of straighforward function in datastage ?

Regards
Sreeni

You can read excel (with some limitations like - no macros ) using a java api . Register the .so in the unx box.

Regards
Sreeni

Checking the processor type in solaris -

isalist -v

In addition - if you are using double monitor in office and then try to login from home (having single monitor).

Regards
Sreeni

Hi all

Using partitions in datastage against a noparallel table in Oracle makes the job to run slowly.

Should we not use datastage partitions against a 'noparallel oracle table' ?

Any advice would be highly appreciated.

Regards
Sreeni

I think this
--
StringToDate(stgAcctDate, '%1950yy%mm%dd') else SetNull()
--

should be this

StringToDate(stgAcctDate, '%19yy%mm%dd') else SetNull()

An invalid xml cannot be defined 'explicitly'.
It can be a
1.0KB file
2.incomplete xml file
3.xml file with inapproriate start or end tags
..

Hence its better to continue the sequencer on 'abort' and have some other db check (number of records loaded) to stop the job further.

Regards
Sreeni

There is a JR on this.

http://www-01.ibm.com/support/docview.w ... wg1JR32113

Is it on 32 or 64 bt ?

Regards
Sreeni

One question:
Any idea why the 'product_info' tag is not 'ending' ?

I think he is asking where to get the training NOT how to get around with the training material

Regards
Sreeni