DSXchange

yes..looks logical

Thanks

Regards
Ulhas

Hello guys I have a question about writing a expression.If i am using a string function (ex.concatenation),will it be efficient to write derivation directly in column derivation or calculating it first in stage variable and then assigning it to column derivation will work faster Thanks for your help...

Hello guys

Does anyone has a link, which explains DataStage Architecture in detail?

Thanks

Regards
Ulhas

Hello guys

Can anybody please clarify ,what is the difference between 'Create cluster Key Change Column' and 'Create Key Change Column' option in Sort Stage ?

From reading the doc,both the options looks similar.

Thanks in advance for your help

Regards
Ulhas

you can use a copy stage to copy it to 10 different links and then put a funnel stage to combine them

IsNull function returns true when a expression evaluates to Null. It may be the case that all the values in col2 are not null which is causing this condition to be false for all the rows. Did you tried using IsNotNull. Not Sure if that will solve the problem but you can give it a try.

Refer to DataStage Parallel Job Developer Guide.Its a nice document to start with

Hello Friends

Is it possible to use a different configuration file, for a particular stage in a job ?

For ex : The job is using a four node config file ,but a particular stage is needed to be executed on a 6 node configuration file. Is that possible ?

Thanks in advance.

Regards
Ulhas

what is IDOC

Regards
Ulhas

This can be also acheived using Filter Stage. Not sure if conditions on multiple columns can be placed in the single filter stage. If not supported,you need to use 3 filter stages.

Regards
Ulhas

you can use a filter to check for the condition and put a copy stage with 3 output links to make 3 copies of the filtered record. Then output of copy stage can be collected together using a funnel stage.

Regards
Ulhas

Using aggregator count rows,we can separate unique and duplicate values but my requirement is directing the records to different files

I guess,using aggregator and followed by filter,we will get the output as

File1
1
3
5

File2
2
4

my requirement is

File1
1
3
5

File2
2
2
4
4

Hi friends

Can you please help me with the logic for the following requirement

Source
1
2
2
3
4
4
5

Target1
1
3
5

Target 2
2
2
4
4

Basically the records with duplicate values should go to a file and unique records should be collected in other file.

Thanks in Advance

Regards
Ulhas

unix split command can be used for this purpose.

Regards
Ulhas

Other option is,set nullable to 'No' for all columns in the source sequential stage and put a reject link there

Regards
Ulhas