DSXchange

Maveric wrote:How are you inserting the data into the table? ODBC, oracle enterprise stage, etc. load, upsert?

i am inserting using Oracle Enterprise stage,Upsert option.i am disabling the update by using false where clause like 1=2.

My Parallel job is getting aborted with "ORA:-02291-Parent Key Not found" error while inserting into the table.This error is since i am inserting the values into a column which is defined as a foriegn key of other column.If the values am inserting does not match the values of the reference...

Hi All, I am Extract Data from .csv file, and loading to Oracle Database. I am using StringToDecimal Conversion but i am getting 0 instead of actual value in Target Database... Input is .csv file it's a comma seprated and partially Quoted file... i used the following methord but i am not getting pro...

I am the OP Minhajuddin....Sorry for the Confusion!! The Remove Duplicates stage gives you the choice of removing the first or last record in each group. Sort your data by LEAF_NUM_ID, LEAF_NODE and DESCRIPTION (and hash partition by LEAF_NUM_ID and LEAD_NODE) ahead of your Remove Duplicates stage. ...

Thannks Ray ..For Your Inputs work around with your inputs Minhajuddin : Thanks For Ur responce!! For LEAF_NUM_ID,LEAF_NODE are Not Null Columns Only in the Target But Unique Index is there on Both the columns,I have checked the constraints ,Please find the below script CREATE TABLE OFSA_LEAF_DESC ...