DSXchange

Are you sure, the bottle neck is in transformer? What are the other stages you have used in the job? Are the performance statistics of the other stages looking good? Post your analysis please!

See, if this helps

viewtopic.php?t=120154

Did you try to Insert/Update data using any database access tool? If yes, was that successful?

Just to make sure you are not making any mistakes with schema/table/column names.

echo $APT_CONFIG_FILE would give you the path for the config files

Just try this...I haven't try my hands on this.

Uncheck the RCP option if it is enabled and give a try.

As an alternate, the table can be created in target first and you can use datastage to load.

Is it a direct load or do you have some other logic in between?

my qst is

"My question is"

how can u achieve

"How can you achieve"

Finally, why do you want to acheive this logic particularly in transformer?

I am just using Auto partition in all stages. Try to specify "ordered" or "round robin" collection methods in dataset and check the warnings are existing or not. I hope "sort merge" collection method automatically imposed by DataStage behind the scenes as you have a so...

Just verify, whether the output format (date and time) of the function "CurrentTimestamp()" is matching with the timestamp format of the DB2 database field LST_UPDT_DTTM.

sequnum=(empno*2) - 1

I don't think "sequnum=(empno*2) - 1" would solve the purpose for the given sample data, considering the fact that employee number is not in sorted order.

I believe "sequnum=(@inrownum*2)-1" would do for you.

Do you find any reason for the "UPSERT" option, not to work in your case?

Note: Post your questions in appropriate forum.

Did you try "trim" functions by any chance?

Convert data from the sources to Uppercase and do the lookup.