DSXchange

Look into sqldr error in scratch directory . I guess you are trying to insert a invalid value which oracle is refusing to load

Hi Ray, What i meant by "duplicates across different runs" using transformer stage is that we need retain the same record( based on the fields which are not part of the sort keys) and reject other records to maintain consistency. .I was able to do that using sort option (key fields)in the ...

I need to remove duplicate records and used sort stage to do that . I used keychange option to flag the duplicate records and use the filter stage to get the duplicate records for exception logging .(since remove duplicate does not have a reject link) . My requirement we need to reject same record (...

Ray , I dont think we can have reject captured for oracle enterprise stage, when we use bulkload option.we have to see the log file in scratch directory to find this . Also one important point to note is eventhough there is error and the error count is below 50 , datastage will report that everythin...

For getting the Max key i used the lookup stage to get the max value generated during previous run . Some of the other options suggested works only with server job .

Since you have a windows version not sure why you get messages like in /C=/Ascential/DataStage/PXEngine/etc/standalone.sh is being used.

Correct me if am wrong , what i know is nodes are assigned to a processor and we can assign the node where it need to run in the node map constraints . But we may not be able distribute the load as per the requirement (50-30%)

it seems you are running out of diskspace , since available space is less than "size 553973128 bytes"

That is correct , in case a server name is specified for the host when you connect to datastage you dont need any change, if you use IP address you need to

I dont think there will be any impact other than changing the IP address for the host system (the server where datastage is installed) .If the database is installed in a different server other thn the server where datastage is installed check with your DBA to configure it accordingly

Nagesh,

I had the same problem , but it strange Datastage behaves that way
To fix this remove the links and again attach it with input link to be the first one to be attached to lookup . This is need to be done ,eventhough the link order may show that it is in correct order

change the field delimeiter as the pipe symbol , and quote as double confirm whether the settinga are as above

is the input data for CPW_UPDATE_DATE Date or timestamp ??

Did you define the fields as varchar ???

Is the derivation checking for the same condition always ?? . in that case You may try switch and then funnel stage .