DSXchange

Do you want to calculate the profit percentage based on Product id and country id or using Product id adn country id seperately?

are you doing this based on any key olumn?

Please provide some sample data like how the split is happening.

Use sparse lookup if you want to pass the value dynamically, but this is preferable based on the amount of data you are having it in source and reference link.

Dataset doesn't allow to have 2 columns with same name. Please be clear, are you going to have same value on two columns?

Output Reject option is available only for Write method = Upsert in DB2 Enterprise stage.

Try Convert() function.

Check the director for any warnings.

tools-->reporting console

Try reading the file as single column. process the records sequentially. using stage variables you can combine the transaction and addenda record.

Your timestamp string should be varchar(26) with milliseconds.
Convert Varchar to timestamp StringToTimestamp(i/p col,"%yyyy-%mm-%dd %hh:%nn:%ss.6")) and then apply the IsValid function

Is your job server or parallel?
If it is parallel then enable the microseconds checkbox in the extended properties and propogate till your target.

Use cleanup resources in director and clear the status file.

There is a high possiblity that load from /dev/null command will lock the table. Contact your DBA to release the lock and try.

The constraint should be based on the number of nodes the job is running.