DSXchange

Hi all,

How to convert UTC time stamp(for example '2016-08-10T18:27:23.3270000Z') to valid Oracle time stamp ??

Thanks

How can we create a rule set in Quality Stage. Does anyone have examples of customized rule sets. Im trying to understand this by using the manual but cant seem to figure it out. It will really help if someone can provide me with an example of any rule set and what it is used for.

Thanks a lot

Deepak, I have tried the both validations and it gave me two warnings for first validation as At row 1, link "DSLink8", while processing column "Dptr_Sch_Tm" Value treated as NULL Attempt to convert String value "05:30:00" to Time type unsuccessful At row 1, link "...

Hi all, I have a job which writes from Sequential file to Teradata database. one of the column in Sequential file is defined as Char of length 4 which typically shows time as '0530' which is 05 hrs and 30 min.I am trying to convert '0530' to a TeraData 'Time' datatype of length 8 in the format hh:mm...

[quote="kris007"]Can you post the input format of your date and also the derivation you were trying to use?[/quote] My input date format is CCYY-MM-DD and the derivation I am using in the transformer is oconv(SLK_DW_322MSG_TBL.LAST_FREE_DATE,"D/MDY[2,2,4]"): " 00:00:00.000&q...

Hi , I have a job which has DB2 as source database and target is SQL server database.And we are SQL server bulk stage for the target. I have a column in source with datatype Date and length 10 and trying to convert this date stamp into the sql server date stamp.And in the target the column is of len...

[quote="meena"]Hi Shiva, When you view the data from the stage you will see both the internal format plus the external date too. And date representation will be showed in the database. Can you post your expressions.[/quote] I have used the derivation given below as If IsNull(GetData.LAST_F...

Hi all, I have a column with data type Date and length 10.It is showing as 06/02/2006 in the database but when I am looking at the view data in the db2 stage in the datastage designer it is showing me as "14033 (2006-06-02)". Now I just want to move the only date 06/02/2006 to the target s...