DSXchange

Hi, im loading a hash file from a oracle View, which has around 4000 records. The hash file is loaded successfully. The problem is for few records junk values are there along with the required value EX: 129943 enfienf 129943 is the required value,but im getting a junk value "enfienf",along...

its just a one to one load. im loading the discount_id (NUMBER(10)from staging to target. there is no trnasformation invloved

Both my source data type and the target data type are numbers.

im using Oracle stage ..
i need to update few columns after the insert process. in server edition there is an option to execute the after SQl queries. is there any similar feature in PX ?

hi,
we have just moved from server to parallel Edition.

can any one help me to write before sqls and After SQL in the Parallel job .

i have a source field named discount_id number(20) when i try to load into the target table , im getting the follwoing error (parallel job) Oracle_Enterprise_0: When checking operator: When binding output interface field "DISCOUNT_ID" to field "DISCOUNT_ID": Implicit conversion f...