DSXchange

Is it the same status for other jobs? Is it the same on other machine?
Have you tried command line compile, will it take the same time? Was your server busy with something else by the time you complied the job?

Wow!!! Thats is a great history told!!

If Var2 (Previous record) is same as Var (current record), it should give you "Duplicate".

Check the logic on how you update the records. It might be a case that even update go in as Insert with new surrogate key.
You can give use more specific cases that on which case the duplicates occurs. Is it all the records from the source bee populated as duplicate?

What is the job desing? Do you have any other error/warning messages?
Reset the job and check if you were able to get any more information in "From previous log..." event.

Hi Sateesh,

Try changing your config file to skip the node 6 alone and check if you job finishes within expected time. So that you can nail down you problem.

Use split micro seconds and rest of the portions. And you can use SecondsSinceFromTimestamp and multiply with 1000000. Add the microsecond and the resultant. Now you can manipulate as you wish.

So stored procedure which calls the function will be the preffered approach.

As I mentioned earliar, the records that are not present in Before is INSERT. (NEW records).

1. You cannot do. Stage variable are limited to stages. However, if you can pass it to a column value and pass the column value as an input to a stored procedure which creates the table. 2. If you intend to get CMG_LIST_4, pre process the Job parameter as required and pass it as just CMG_LIST_#JobPa...

Add a sequencer which will connect all the streams of the JobSequnce for ALL condition. Which will ensure the successfully completion.

Its more of a DB2 log. If you dont want to insert the data whose key is not present in parent table, do a lookup and reject those records based on unavailability.

What is the size of the file that been loaded? Is it too bit to fit into virrual memory?
Have you marked APT_DISABLE_COMBINATION to true as suggested by Ray.
This option is available in project wide in adminstrator or in transformer.

Ok going back to your question, if both the key fields are same and all the values specified are same, it comes through Copy change code, which includes city name and zipext. If you are just testing it, allow all the type of change code and analyze what record came with which change code. It will gi...

Hi,

Check the data type for the field ACTIVITY_MAPPING_ID.
It is complaining that, the data 'ID' is not accepted for the given data type.
May be a Header line.