DSXchange

How much memory do you have available? This will be one of the primary criteria.

Good catch. Familiarity!

Resist silly requirements. Either you're migrating the OWB code into DataStage or you're not. Which is it?
You have version 8. Therefore you have the DataStage SCD stage, which can do both Type 1 and Type 2.

Just wrap an UpCase() or DownCase() function around whatever it is you're comparing.

The Link Collector stage is notorious for this behaviour. It takes Round Robin to mean "wait", rather than "skip if not ready". It does not process the "end of data" token gracefully. You could cat the files together in a Filter command then, within the job if you want to, use Link Partitioner and L...

255 and 254 don't work because they are used internally to manage the structure of hashed file storage. It's a limitation, but it's one we've learned to live with.

There is nothing in the product to clear the job log while its job is running. Log purge occurs on successful completion of a job. So the "requirement" would have to be solved with a routine. Personally I think it's a silly requirement - why not tighten the auto-purge setting for that job to, perhap...

Where is "offshore" from Hyderabad?

The obvious question is "why not just use a SELECT"?

@OUTROWNUM can never violate a unique constraint on a truncated table. Check for any other unique constraints that there may be. Check too that you are loading the column that you think you are with this sequence of integers - that is, verify that the design is doing what it is supposed to be doing....

Ragunathan Gunasekaran wrote:Any clues on the post

This kind of post is totally unnecessary and, done too much, offensive. You are very close to "too much". Please desist.

If you want guaranteed quick response, that can be had, but not for free.

You haven't even shelled out for premium membership!

Use Num() or IsValid() function in Transformer stage.

Or just rely on the fact that something that does not match the picture won't make it through the CFF stage to the normal output.

There is no limit to the number of nodes you can specify.

Please give your hardware vendors a call - they will be VERY PLEASED to hear from you.

There's not really an issue. The alert can be ignored or demoted if you are totally certain that the values coming in the larger structure will fit in the smaller, and if you are not 100% certain of that then you have to take steps to ensure that any too large value is rejected rather than causing a...