DSXchange

Hi, i am Using doing lookup and loading the data into Target.Target table contain Unique Key constrants,so i used remove Duplicate for that feild but it still showing the Error: ORA-00060: deadlock detected while waiting for resource. Please tell what are the reasion for this error. Regards, Sandeep

Hi I just want to convert source string DD-MON-YY to target feild date in this format YYYY-MM-DD.
I am using parallel Jobs,source and target are oracle enterprice.

Cloumn Definition for Source:--
Name--amount
Type--Float
Length--15
Precision--blank

Column Definition for Target:--
Name--amount
Type--Decimal
Length--22
Precision--blank

Hi, I am doing following conversion form flat to decimal using :--DFloatToDecimal(SrcIvrTran.sequence) but it showing the following warning massage:--APT_CombinedOperatorController,0: Conversion error calling conversion routine decimal_from_dfloat data may have been lost How to resolve that warning....

Hi Thks for replyig.I already use peak stage and it showing data but when i connect it to Oracle Stage then it showing the warning message that "Data may be lost in this conversion" and din't inserting the data into target. I also tried it with Sequential file as target then data is loadad...

hi I am using .CSV file as a source and Oracle as Target. Source format is dd/mm/yyyy(String) and target format is Timestamp it doesn't matter the format in target but it should be Timestamp value... I am using Oracle Enterprice stage for Target. I didn't specified the column size in the Source,beac...

hi Question:-- to what level of precision? Ans:--Without Precision Source format is dd/mm/yyyy(String) and target format is Timestamp it doesn't matter the format in target but it should be Timestamp value... Question :-- which Oracle stage? Ans:--Oracle Enterprice This is the complete vale i specif...

hulett, This is the information required by you... what is it in the target table - DATE? TIMESTAMP Answer :-- Timestamp what stage are you using for the Oracle piece of this? Answer :-- Oracle stage in PX and the other thing the job is successfully run with some warning. but it doesn't updating the...

Thanks for your speedy reply . Actually My input is a CSV file am reading in Sequential stage ... and Transition_dt is one of the input column in dd/mm/yyyy and Iam passign this value through Transformer and my Traget is Oracle where datatype of same field is Timestamp .... So i need to convert my i...

Hi
Thks for replying.but i am using parallel job Transformation and Unix operating system.Plz solve my Query.

Hi, I am using CSV file as Source and Oracle as Target.Now i want to convert string to timestamp.The source data format is dd/mm/yyyy and the required format is yyyy-mm-dd hh:nn:ss.when i tried it showing the following Message: Conversion error calling conversion routine timestamp_from_string data m...