DSXchange

Hi, I have input data like this date , closingbal 12thmay,2000 13thmay,3000 14thmay,4000 17thmay,6000 20thmay,8000 and i need output like this date closingbal,openingbal 12thmay,2000, 0 13thmay,3000, 2000 14thmay,4000, 3000 17thmay,6000,4000 20thmay,8000,6000 means my last transactions of closingbal...

Hi,

Pleas can any body tell me whats the use of checksum stage on which scenario it will be usefull for us

Hi ,
Thanks to all for giving suggestion.
I resolved this issue.
While loading the file i used the option Field String format is "Dos".
Now i am able to load the data in target DB with out special characters.

Thanks,

Thanks For You reply.
I am getting special character as ^M.

How can we remove this while loading into the table.

Hi,
I have given the padding string as 0x20.But it doesn't work.
I think some where are getting strucked.

Hi ,
I am not able to see the special character.
My file is comma delimeter with Double Codes ("") for every column.

Hi Carg,
Thanks for your reply.
B column is varchar.Even though i tryed using the Environmental variable.

But i am getting the ouput with special character as Square.

Can am one help on this?

Hi,
I am not able to see the special characters in unix level.
It is the last column .
I am getting this data with special characters in oracle when loading the data.
Can you guide me what are the steps to be take to get rid of this special character.
Thanks,

HI,

My Source is .CSV file.
I am loading the data into the target DB Oracle.
Columns:
---------
A,B
1,a
2,b

When i loading into the target .It is loading all the records.
But the data for Column B like a square symbol.
I need output as a.
I appreciate your help.

Hi , In lookup stage i am facing an issue My job src->trans->lkp->trans->db | File---->trans src input: A,B,C 1,AA,23 ,BB,24 File: A,B 1,AA ,BB I am using lookup Before lookup i am using NulltoValue((A),'Null')from source But it was not working can any one guide on this

Hi,

I am geting the below data in traget
soucer date formate: 06/12/2011
but i am geting output : 06//12//2011

i want like this :06/12/2011

Sourcefile --------->FTP file

filed data type in source : Varchar
filed data type in traget : varchar

please help me

regards,
Raghu

HI ,
Thanks
I got the solution by using @INROWNUM.

Thanks & regards,

Hi to all,
I strucked to generate the sequence number can any one help on this

My input Column
A
-----
3
Having value 3.
I want o/p
B
--------
4
5
I want to incrrease the number from input coumn A to Target column B.
With out using the oracle sequencer.
Can any one?


Thanks & regards

Hi to all,
Please give solution for this.Still i am not able to get the solution.

Thanks

Hi,
I.e mm/dd/yyyy format