DSXchange

Hi,

I have got some aplhanumeric values like 9125a, 9625aa. Now I need to convert the 'a's into 0. So, it should be like 91250, 962500. Plz give some hint how to do it in transformer.

Regards,
Arnie.

Thanks for the reply.

Actually the i/p to the sequencial file is the o/p from a server job sequencial file. And surprisingly I am able to read that with a server seq file and not with aparallel seq file.Really confused!!

Thanks,
Arnie.

Hi,

I am unable to read data into a sequential file.
Error: Bad trailing quote character at field "DateDrawn"; looking for '34' but found '0', at offset: 161

DateDrawn is a timestamp field
Not getting any clue of it . Plz Help.

Thanks
Arnie

Hi,

I am unable to convert 28-09-2008 01:01:00 to 2008-09-28 01:01:00. How to do this with Iconv and Oconv.

Regards,
Arnie

Hi,

New to server jobs.

Please tell me how to convert 01/01/2008:08:08:00 to
01-01-2008 08:08:00


Regards,
Arnie

Hi,

I am getting this error:
Transformer_38,1: Invalid character conversion found converting to ISO-8859-1, substituting.

guess I need to convert NVarchar to Varchar.

Please let me know how to do this in transformer.

Regards,
Arnie.

Actually what I want to do is to make one column a row and so we will have it in matrix format.......
then the corresponding matching cells will be marked #.....

Hi, I have a set of records like machinedesc machinegroupid machinegroupdesc AAAA 1 b BBBB 7 a AAAA 2 d BBBB 3 c XXXX 7 a now I want this as a cross tab like: 7 1 3 2 a b c d AAAA # # BBBB # # XXXX # and save in a file Please help. Regards, Arnie.

Hi,

I have a name like 'John Watson'. Now I want it like 'JohnWatson'.
Please tell me how to do this in transformer.

Regards,
Arnie

Well, actually I am new to server jobs and hash files.....what I am trying to do is a delta load....in the first run itself the job got aborted with that error..... So my doubt is... should there be a hash file in the directory before the first run?? Please tell me how to do this.... Thanks and rega...

Hi, I have got an error when I tried to use a hash file for look up. I am unable to get the solution. Below is the error: CUSTOMERFORM_Delta..hLkp_F_TCLIENT_CONTACT.IDENT1: |CUSTOMERFORM_Delta..hLkp_F_TCLIENT_CONTACT.ILkp_F_TCLIENT_CONTACT: DSD.UVOpen mkdbfile: invalid number of arguments SH: line 2...

Hi, I have got a complex scenarion. The below the the sample source data. Items Date transit value($) on hand value($) Shocks 01/02/08 0 1 casual wear 01/02/08 1 0 underwear 02/02/08 2 2 sports wear 01/02/08 5 9 now, all the DATE values should be same. If there is a mismatch( as in the above case),t...

Hi, In my previous job there was a lookup(fail-fail). But now I need to change it to JOIN as it cannot handle a very large volumn of data. But I am not able to fail the job when the conditions are not met,in the JOIN. So I am thinking of failing the job in a TRANSFORMER after the JOIN. Plz let me kn...

Still having a problem. The total records from both the links(before and after) gets added up in the change capture stage. What may be the reason for that???


Thanks
Arnie

Hi, I want to find whether 2 file are matching or not. I have used the change capture stage. Before that I have put sorter to sort the data. But no record is passing after the change capture stage. Warning: Change_Capture_284: When checking operator: User inserted sort "Sort_275" does not ...