DSXchange

What do you mean by 'junk' value? Is there any pattern or is it constant value? Is there any default in the column?

What if you also map it to a sequential file?

Btw, the question is marked for server and hence APT_PADCHAR may not be the reason.

You do not have funnel in server jobs.

But depending on whether the output is database or flatfile or any other media, you can change your design.

For example, if database, you can insert as separate streams.

Btw, what must happen if any of the 2 column value is 00 or blank ?

Design the job to perform reference activity such that the load is only 'load with truncate'.

Do it in two steps - one truncate and custom SQL.

Btw, what you expect to do as 'custom' ?

You can constraint the transformer to meet your requirement.

If you are bit clear on what you have tried, others can assist.

Will the same job run in more than one invocation with different parameters at the same time? If no, you can try the following 1.) take copy of DSParams to some default 2.) append your list of parameters and make it DSParam This way, you can use environment variables which will be assigned by your e...

Champa,

Sequence are basic jobs. So you can call both Server and Parallel from it.

Sort in Server and Parallel must be identical. If you provide more information on the source and settings in your sort stage, someone will be able to assist.

DataStage provides you information about count of rows processed with other information such as time taken, CPU utilized etc. You can extend it further to extract and store in external media (i.e. outside DataStage) for audit. If you plan carefully, you can also automate this with proper naming conv...

It may be useful to do a binary ftp transfer. This will guarantee any value conversion.

You might have already checked this....but can you verify that the a.) keys with which the hashed file is created contains the same key you expect in the reference b.) the key in the current job under discussion is correct Also it will be helpful if you can locate few values in hashed file which are...

Priyadarshi,

That was the problem I wanted to say with preserving the partition due to which you cannot run a high node dataset in a low node configuration.

Thanks for putting it with practical terms.

It appears to be ^0, null value in bin.

Or orchadmin.

Are these interview Qs ?

Arnd,

I know it is possible to read 2 node ds via 4 but may have issues doing vice-versa.

But can you explain how 10k via 2 node became 25k in 4?

Op says

My requirement is DATE_PURCH<>'1900-01-01'
it is ok

Is the question

i have to handel null for it

If yes, assuming source is char at this point, it will be

NullToValue(DATE_PURCH, '1900-01-01') <> '1900-01-01'