DSXchange

I'm not sure if this has been discussed before. Is it possible to load a parent and child table using 2 links going to the same Oracle connector? When I join multiple links, the connector gives me a link ordering tab. I'm not entirely sure about the dynamics of a scenario like this. Any help would b...

Hi Vaibhav,
You need to quite simply call the unnamed block in the after-sql in the below format - I tested it and it works well

The key source is an Oracle sequence object while the gap feature you mention probably applies only to state files. Thanks for the response though. After several rounds of debugging,we narrowed down on the possible cause. Posting this for posterity - The Oracle Database is an Exadata machine that ru...

ArndW wrote:That sounds odd. If you change to a 3-node configuration, does one node also show incorrectly generated keys? ...

To answer your question, one node (the same one in every run) always has the older set of values. All nodes are on the same machine

We were initially getting a mix of correct (current) keys and old ones. As part of the troubleshooting, put a node constraint once on each of the 4 nodes and narrowed down on node 4 that was always coming up with old keys. I presumed that it was probably because of the caching of keys on that node b...

Hi, We're facing a peculiar situation where a sequence generator stage that generates surrogate keys from an Oracle sequence object (with a cache of 1000) generates the right values in 3 out of the 4 nodes. But the 4th node seems to be generating values way before the CURRVAL of the sequence object....

Craig and Ray, Thank you for the response. We did a sanity check to ensure that there are no alternate processes trying to generate the key without the sequence. We even went so far as to tweak the security so that only the system id can insert rows into the table in question. The only thing that ha...

Hi, I'm not sure if this is a DataStage issue or a Database issue. I have a transformer that has 3 output links. Each output link uses the NextSurrogateKey() to generate a sequence key from an Oracle DB Sequence object. The upstream and downstream all execute in parallel. I get erratic PK violation ...

Hi All,
Just wanted to check if "2015 May Day Offer" is still applicable? I still see it in the memberships page

Hi DS Gurus, I'm reviewing some of the code built by my peers and came across a scenario where we are not (and never will) dealing with UNICODE data. But all the metadata(output definitions) within DataStage have been defined as UNICODE. The jobs are fairly complex with lookups, joins, change captur...

Hi All, I am trying to view the data in a date field in a dataset but all I get are these * characters. Not sure why. The datatype of the field is DATE in DataStage but when I try to load the Oracle table, it throws an error. I'm trying to catch the culprit but the Dataset isn't showing me the actua...

Thanks for the reply, rkashyap.

The semicolon delimiter didn't work. The comma delimiter worked though. Also, each sheet had to be individually enclosed in pairs of single quotes. Must have something to do with the way our environments are configured.

Hi,

What is the syntax for specifying the "Sheet names to skip" where there are multiple sheets that need to be skipped and have spaces in their names?

I'm leaning towards a corrupt installation as well. Thanks for the reply Craig

There seems to be something wrong but I'm not sure what. When I open the standardize stage (or even the MNS stage), all I get is a window like this. Shouldn't there be options to specify rule set, et al? What's not right here?