DSXchange

It's not all that different from what you posted. Write to a hashed file keyed to remove duplicates in your data. Create a reference link to that same hashed file so that you are writing to and looking up from the same hashed file. Make sure the reference stage has the 'Preload' option either set to...

Those cwazy Others, whadda they know?

How did you try what they said? How is it not working? Details, man! If people don't know what exactly you've tried and in what way it didn't work for you, how can you expect them to help? Besides, it can save us all from alot of pointless posts... "Did you try X? "Yes." "And did it work for you?" ...

but in data stage varchar of length greater than 500 is not supported. while running the server job i am getting this warning "Invalid precision value. Error in parameter 62." and the is not loading into this column. Of course you can handle large string values in DataStage, I've loaded 4K - and up...

As noted, 'Enterprise' stages are only in the PX product. Always been that way. A couple of points. You can't just choose the 'Fully Generated' option and then click 'View Data'. There's quite a dance you have to go through to actually help it 'generate' the query. It works from the metadata in your...

What was your 'minimum modulus' setting in the stage?

Ah... good. :D

Hmm... only if you are doing a new install or one where you import your old project export. An 'upgrade in place' of an existing installation will not require a recompile.

I had no idea anyone had a .dshome file in the root directory. You mean it is not a common practice to use the DSHOME environment variable? Just for completeness here... One constant across installs is the presence of a .dshom e file in the root directory. Since the $DSHOME can be anywhere, the .ds...

In other words, you can use pretty much any one you want. Learn to love 'dsjob'!

Nonetheless, the positional parameter marker ("?") complies with the SAE Access Group SQL standards, while the Oracle practice does not. Nonetheless, I find the positional parameter marker to be a PITA and the Oracle ones to be much more practical. I just needed to build a custom ODBC query with tw...

IFMTCS wrote:Is there any Stage in DS to call a java program

Yes - if you purchase the JAVA Pack.

Which 'filename'? The first column contains the name of the file(s) read. And the name of the folder itself should be a parameter.

Well... this is where you move beyond my meager ability to help. I'm not following your input xml or exactly what you'll need to do to get that flattened out and into Oracle. Speaking of which, do you have a target Oracle table defined? Might help to post that DDL so people know what you are shootin...

Hmmm... this is where it gets hard to help without actually being there. Is there anyone onsite there with you (even if they don't know DataStage) that knows XML and could sit through the process with you? If you don't think you've imported the metadata correctly - give it another shot. Make use of ...