DSXchange

your data types should be source column a (decimal(19,2)) target column b (decimal(22,5)) you wont need to use DecimalToDecimal fuction as this will be implicit conversion. Also you are receiving value as 000000000000000.00, because you must have have set you default value as 0, because the record i...

you were suppose to search word 'contention' in a dictionary...Just a joke :) sorry if you find this comment rude But as jwiles said., you are facing i/o contention...multiple processes reading the same file..there is going to be a resource sharing between these processes..which is causing the slow ...

have you tried using a filter for D1.C3='' and D1.C4='' condition before or after you use the join stage.
In join stage u can have
D1 left join D2 where D1.C1=D2.C1 and D1.C2=D2.C2 condition

$APT_GRID_PARTITIONS Specifies the number of partitions for each compute node.
Hence when you specify 4, the data is partitioned on 4 partitions, but when it is 1 all the records go to a single partition. and hence the output is desired output

Thanks

what do u mean by UNVARYING method and FURTHER compilation

In my project i handelled this requirment in unix by writing a small shell script
head -1 sourcfile> header_file
tail -1 sourcefile>trailer_file.

you can also use a start loop and end loop stage and loop through your job 10 times

Could some one please tell me why tranformer logic is compiled as C++ and why not other stages?

Thanks!!

How about asking the source system to send you the field in which you are expecting pipe,comma as data itself in quotes(single, doulbe etc).
eg.

A|B|"C|"|D

As Ray suggested it is preferable to use user defined sql when fetching data from any database using stages like ODBC,Oracle etc.
your case is a perfect example for such requirements

Where in Datastage can i change the 'warning level limit' to maybe 5.By default it shows as 50 but when i change it to 5 in director, this affects only my userid, if i run the job with some other user id the value shows 50 again. also let me know if we can set these warning levels individually for j...

Thanks!!

Hi,

What i wanted to know is that if there are 3 stage variables defined in a transformer namely a,b,c..which stage variable is dervied first, is there some sore of orderring that needs to be mentioned in the transformer properties.

Thanks!!

You need to sort your input as change capture stage assumes that the input is sorted