DSXchange

You have posted in Server forum but marked your job type as Parallel. Assuming your job is parallel, you can use Sparse lookup to do the lookup against the db2 table. Also, if you are reading only the key fields from the db2 table you can still use the normal lookup to see how long it takes to read ...

It depends on the requirement you have. If all those stages have the same number of records then there won't be much difference performance wise. DB2 might be slower by the time it takes to establish the connection to the database (on the same server or remote server).

Depends on what you want as your output. Do you need the date or the number of days between the dates? If you are interested in Date as an output, you can convert the dates in Julian, find the difference and then convert it back to Gregorian. I have done that in the past successfully.

You can use a copy stage after your Sequential stage and define two output links from the Copy stage-- one for the lookup and one for the aggregation.

But I am not sure whether StringToDecimal function will work or not.We need to use another function i guess. As you say, changing the data type on output link has worked. If we have any specific function it would be great. Well..For a start you can start using it and test it to see if it is working...

You can just define the datatype on the output link as Decimal and most of the times that should be enough. If not you can always use StringToDecimal.

Does it need all the little date and time pieces in there to work? Because you are using TimeStampToString, the function expects you to describe the way the timestamp in the input data looks. If all you are interested is the time part of the Timestamp you can use TimeStampToTime and then convert it...

Usually, Aggregator Sum/Difference output is defaulted to Double ( datatype). Try changing it to Decimal and you should be good.

That applies only to single input and single output ... if we use a more inputs it should be set to False ?? You should be aware that Copy Stage can only accept one input link. It cannot accept multiple input links. The default setting is FALSE and the help within the stage is quite self explanator...

It should be Same applies in Transformer stage.

DB stage does not support two input links. What you can do is use the two separate links - one for update, one for insert and use a funnel stage with those two input links and the output of the funnel stage goes to your DB stage. That way, there is only one link that accesses your DB and you won't h...

Last time I tried it, it was fine, but many things were added to the jobs since then. Doug There lies your answer. You will have to figure out what component that was added might have caused this issue. I asked earlier but I'll ask again. Are there any warnings in your director log that is causing ...

Did you try specifying the quote character specifically at the column level? Can you try doing that? I remember doing something similar but can't recollect the exact steps.

Is this a Job Sequence or just a parallel job? Are you getting any warnings before you get the SIGINT error. Can you post any warnings from director log? Couple of reasons why SIGINT error occurs is when someone tries to stop the job or if the number of warnings exceed the limit mentioned in the Job...

Short Answer : NO.

However, there are couple of Stages in data stage that can perform few of the functions as the transformer like Filter, Modify