I am newbie to DS, I am trying to load the data from one staging table to the warehouse table (One to one mapping) , i am using the PX transformer also in between these 2 oracle stages.
When i am loading the data into the datawarehouse using the option LOAD and truncate it was working fine.
But when i am trying the option with the UPSERT , Userdefined Insert and the Update option i am getting some errors like
InsStgAmt,1: Operator terminated abnormally: received signal SIGSEGV
InsStgAmt,0: Operator terminated abnormally: received signal SIGSEGV
In the userdefined Update SQL statement i am giving one false condition like Where 1=0 .
(The main thing for using this false condition was i dont want to update the table, only insertion without clearing i need ) here i can use the insert option but if there is any error occured while loading into the dwh i want to load into one Error table , in that Error table i am having one field like SQL_ERROR, if i am using the UPSERT option means i will get the SQLERROR data also and i can dirrectly map that data into my Error table. If i use the truncate and load option means i can't handle the error
Regarding the SIGSEGV Error ,while doing the UPSERT option
Moderators: chulett, rschirm, roy
-
lydiapeter
- Participant
- Posts: 1
- Joined: Fri Sep 07, 2007 4:57 am
- Location: Kochi