DSXchange

Thanks

But under Upsert mode i can see 4 options

Autogenerated Update & Insert
Autogenerated Update only
user defined Update& Insert
user defined Update only

can i go for First option?

Thanks

Thanks

Well these are the options

If we mention Write method as UPSERT then i can see options under Upsert Order (Insert then Update) and (Update then Insert). According to what I understood is as i am filtering out Updates in can use Insert then update as Upsert order. Am i Right?

Thanks

Thanks for your help

Just wondering whether UPSERT mode works for only inserts?

Thanks

Hello Chulett,

You mean to say Zero for both APT_ORAUPSERT_COMMIT_ROW_INTERVAL and APT_ORAUPSERT_COMMIT_TIME_INTERVAL env variables. So if the job fails all the records will be rolled back?

Thanks

Hello chulett, As you said, after lookup against the target table i can send the failed records ( which are only inserts) to a database where i can use UPSERT method to insert records into database. I know there two environmental variables that control the commits. But wondering what are the values ...

Thanks chulett

I want to commit the inserted records after the job has been finished successfully if the job aborts in the middle i will have to rollback. Is there a way thatcan be done with Load option.

Thanks

Hi

I could not see any option called INSERT that is why i am thinking of using UPSERT mode.


Thanks

hello

Thanks for the response. I want to reject that record if it already exists.

Thanks

Hello I have a requirement where i will get the flat file (app 2-3 million records) and i need to insert the data to oracle Database. I am Seq File stage, transformer and Oracle Enterprise stage for this. which is the best way to load the data to Oracle database. should i use load as write method or...

OK

Thanks for your help

Hi

thanks for your response. Yes the input file might have any number of records but i need to produce a file for every 50 records.I have never created custom stages before. Is there a way other than creating custom stages.

Thanks

Hello I have a requirement where lets say i have a flat file with 200 records and after doing some transformations i need to produce a file each for every 50 records. So i will have to produce 4 files with 50 records each. If the input file has 60 records i need to produce 2 files with 1 file 50 rec...

Hello

I want to read the whole first block from Sequential file and want to map that to XML field via transformer and after first block is done i want to continue with second block and so on ...

Thanks

Hello I have a flat file which comes out of Mainframe. The file format is as below H000U002 000 H000U003 000 L001 000 000 L001M001 000 L001M002 000 L002 000 000 L002M001 000 L002M002 000 L003 000 000 L003M001 000 L003M002 000 L004 000 000 L004M002 000 T999 000 000 T999M001 000 H000 000 000 H000A000 ...

ray.wurlod wrote:The usual way is to write to DaySales.xml then rename it in an after-job subroutine. ...

Thanks Ray.

But how can we get MMYYYY value there. Could you please explain in brief.