DSXchange

sreelalpp wrote:Setting 'Continue' option for 'Condition Not met' clause is equivalent to setting no conditions. Correct ?

No.
The default is Fail.

1. No.
2. Yes.
3. Between the keyboard and the chair.

No (it's read-only out of the box) but, if you make a copy of it and edit the copy, you don't violate your support contract.

No, simply mention a second node in the DataStage configuration file (e.g. default.apt) on the analysis engine. Validate the analysis engine - the one on which the ANALYZERPROJECT project exists. You do have to do all the deployment things that parallel engine requires - sharing the parallel engine ...

It won't make as much difference as other factors, such as how close the database server (repository tier) is to the services tier, how fast your network is, and so on.

It tends to work properly when Array Size is set to 1.

Select using Oracle Enterprise stage is sequential unless the table is partitioned. This stems directly from the way that Oracle caches the result set in a temporary table and streams from there to the client.

Dump the database table contents from SQL Server. Use this as a bulk loader data file for the other database. Of course, image data may be coded differently in the other database, about which you have given us no information, so we can not offer cogent advice. There is nothing sensible (using curren...

1. No, but it's easier to do it that way.
2. Doesn't matter.
3. Those should be sufficient, you probably don't even need Pad Char.
4. Up to you.

Any Null Field Value property must contain the same number of characters as are defined for the field width.

We don't do "urgent". If you need urgent assistance sign up for priority service from your official support provider. DSXchange is an all-volunteer site whose members post as and when they can. Requests/demands for urgent help tend either to offend or to fall on deaf ears. Short answer: d...

Use an Open command in the "real data" job to delete the records (if any).

You can use the LastRecord() function. (I think that's what it's called.)

To use this you need to be running version 8.5.

Does it need to be reliably repeatable? Does it have to preserve the relationships between and the statistics of the data?

If any of these is true investigate the Optim product from IBM (or another data masking product). Otherwise you're going to be re-inventing a whole lot of wheels.

Use a downstream Remove Duplicates stage to pass only the last in each group.

Or upgrade to version 8.5 where you can do loop processing within the Transformer stage.