DSXchange

What type of load you are using ?? Load , update , stream ??

What type of load you are using ? Is it a fastload or multiload ? If it is a fast load you can't load duplicates even it is a multiset table .

Do you have any unique primary or unique secondary indices ?

Yes you can do that before running the job ...

Something like this ...

dsjob -run -parametersetname = valufile -paramsetname.parameter = newvalue

Just curious

Why do you want to change the value files ?

If I understand it correctly , you can do by writing a unix script to check the value of that column and if its equal to A proceed to dsjob -run or else wait for sometime ..You need to write while loop i guess

I believe that you are using oracle enterprise stage .If you are facing this issue with a column datatype number then there is known bug . Check the same forum you will get to know more details .

Hi Anusha ,

Do you have spaces in that column ? May be someone might have changed APT_ORACLE_PRESERVE_BLANKS variable value .

you can use a sequential file stage and read it as a varchar . After that in transformer stage you can separate the header , data , trailer information . I believe you are going to take the data in header & trailer for reconcilaition .

why you want to use CFF stage ? Is it multi record format ?
You can strip header and trailer from the file by a transformer

Also Check ulimit command to see the limit on the file size .

These type of errors you will face incase you are trying to update a nonexistant record

Unfortunately I didnt remember how it got resolved . I think we have restarted our server .

Is it the first time you are compiling a job with transformer in the project ?

Are you using waitforfile activity stage ? what is the design of the jobs and design of the sequence ?

Number of rows you are processing depends on the type of query you are using , number of columns you are accessing , number of tables that are present in the query ...whether you are using partition option ..and many more factors ...

duplicates stage , sort stage , transformer stage ......