DSXchange

Hi All,

I am loading into oracle table from a Dataset.
But the job never completes and in the director it doesn't show up any wanings or any status message ,it shows in the running stage.

Please share your knowledge on this...

Regards,
Rafidwh

Hi Gurus,

Do you have any idea to suppress these warnings.
What might be the cause for it.

I get this warning after I validate the date I am using a stage variable to validate the date sv1:IsValid("DATE", StringToDate(DSLink3.Date,"%dd/%mm/%yyyy") ) In the output column the derivation is If (sv1= @FALSE) Then "-1" Else DateToString(StringToDate(DSLink3.Date,&...

out.Date is char(10) and output column is integer (8)

Hi ArndW,

The outdate.Date is Char(10) and its output is int(8)

I created a dummy job taking only Date field and converted the input date field from dd/mm/yyyy to yyyymmdd using the below function DateToString(StringToDate(DSLink3.Date,"%dd/%mm/%yyyy"),"%yyyy%mm%dd") Iam getting the same warning .Input field Datatype is Char(10) and output is...

its an integer data type

Did anyone faced this problem

Hi All, I am getting the following error while converting the date Transformer,0: Conversion error calling conversion routine date_from_string data may have been lost. The input date column is char(10) and the format is dd/mm/yyyy. In the transformer I am validating the input date and converting the...

Ray sorry to confuse it is other oracle stages

Hi All, My source is a Flat file and target is Oracle stage. Source Col: src col1;src col2; src col3 Target:Tgt Col1 I need to update TgtCol1 in table which is mapped with src col1 and the condition for the update is src col2=tg2 col2 and src col3=tgt col3. I am not moving col2 and col3 . Please sug...

I was asked to use only modify stage as per technical document and for your reply should I use a KEEP OR DROP since I need only one column of 72 source column,change the column name and also Trim the column

Hi All,

My source file contains 72 columns I need to keep only one column LIke Src.DATE and change the column name to EFF_DATE also I need to trim the leading and trailing spaces of source column These operations need to do only using a MODIFY stage.

Please throw some light

Regards,
Rafidwh

Hi All, My source is a flat file and this file is loaded into a table.A Date column in a file has Datatype as Date and the corresponding field Datatype in Table is a Timestamp . If I am following to the structure as it is ,the job gives me compilation error like invalid conversion from Date to Times...

Hi All,

How to trim trailing and leading spaces using a modify stage


Thanks in advance,
Rafidwh