DSXchange

No. This has nothing to do with the transformer derivation.
I have a flat file which is comma delimited. The target must be of fixed width column thats all.

Hi, I have a requirement of converting a comma delimited flat file to a fixed width flat file. The data in the comma delimited flat file looks something like this. 1,CSB01B,7.4,SEA01T,8.4,S1A01R,9.4 2,MUP01C,10.4,FSC01Z,11.4,CDE01F,12.4 I want the data to be in fixed width columns in the target flat...

Hi, I am facing a strange problem in one of my jobs. I am using a hash file which is loaded from an MS SQL 2005 db. The key field in this table is 'Customer_SA_ID' which is a surrogate key generated from another job. The problem is when I just import the columns of the hash file and click 'View Data...

This string to date never worked for me correctly.
Even without that null handling it didnt work for me.
Same error.

Hi, I am trying to convet an incoming Date('mm/dd/yy') in Varchar format to Date ('yyyy-mm-dd'). I have used the following function in transformer. If IsNull(LNK_XFRM_REAL_EST_STORES_DM.store_open_dt) Then SetNull() Else StringToDate(LNK_XFRM_REAL_EST_STORES_DM.store_open_dt,"%mm/%dd/%yy")...

Yes the source data is in the form 'yy'. But i want to convert it to 'yyyy'.
Thats why I have put as 'yyyy'. And I am removing the 00:00:0 part from the source using the function 'convert'. I am banging my head for this since past week. Anybody ever came across such a thing before ?

Hi,

Thanks for the response. I tried the below code and got same ****** in peek stage.

StringToDate(LNK_XFRM_REAL_EST_STORES_DM.store_open_date[1,8],"%mm/%dd/%yyyy")

Any idea whats wrong happening ?

Hi Experts, I am trying to convert an input column coming as varchar to Date format. The input is coming in the format "mm/dd/yy 00:00:0" I have used the combination of below functions in transformer. StringToDate(Convert( "0:00:00","", LNK_XFRM_REAL_EST_STORES_DM.store...

Hi,

I tried the following function. But its showing error. I guess the syntax must be wrong. Can anyone correct me in this.

Store_Open_Date = StringToDate(LNK_XFRM_REAL_EST_STORES_DM.store_open_date,[%"%mm-%dd-%yyyy"%])

Yes. The main task is understanding the century. This was earlier achieved by using user defined query in source stage. But the requirement is to achieve this using transformer stage.

Hi,

I am trying to convert a date in Varchar (mm-dd-yy) to Varchar(mm-dd-yyyy). Can anybody help me on this ?
I am a fresher in Datastage.

Thanks in advance.