DSXchange

Hi there,

While doing lookup with sequential file and lookup file set, I got an error message :

Ld_TfmLkp,1: Failed to match node node2 (fastname ascdvdb1) for LUT Fileset /etldata/dv/jour/Ld_Tfm_LFS

Could any one suggest me some info for this error.

Thanks,
RSS.

Hi,

In my case there is no default value like 0 or anything. If source field is null or empty or invalid value, after converting Datatype I should get null in target oci stage.

Can anyone please suggest detail solution for this problem.

Thank You,
RSSV

Hi All, After discussing with my DBA that there are no locks on my table and also no one is inserting or updating my table simultaneously.............. Now I am able to load data into table without any deadlock problem by changing execution mode as sequential instead of parallel. Is it right way of ...

Hi, While I am trying to convert datatypes for few columns like Varchar to Decimal, Varchar to Date and Varchar to Timestamp which are not nullable on the target table, I am getting following warnings: 1) APT_CombinedOperatorController,2: Numeric string expected, got "". Use Decimal defaul...

Hi, I am trying to load data into table which has 205 fields. When I am trying to do so, job gets aborted after loading few records and giving following error message. sqlcode is: -600esql complaint: ORA-00600: internal error code, arguments: [sorput_1], [], [], [], [], [], [], [] ORA-00060: deadloc...

Hi, I am trying to convert Datatype from Varchar which is in DataSet Stage to Decimal which is in OCI Stage for Sequence Number generation.........I tried StringToDecimal(Column) in Transformer and Column=Decimal_From_String(Column) in Modify Stage but I couldn't solve it. Any suggestions from you? ...