DSXchange

First your question is not clear to me. First you need to change the Excel file as .CSV file. IF you are on Unix server you need to FTP the file(.CSV file) from windows to Unix. and after that you can use directly sequential file stage and provide delimiter as , and quote as none. try it out. can so...

Try this function Trim(DecimalToString(Coloumn_name,"suppress_zero"), "0", "L") Hi all, I need some help regarding removing zeros for decimal values. My source is oracle database. iam having one column QTY of decimal datatype(38,10) And my target is .txt file and QTY co...

My input file will have coloumn name system_name. For example if system_name = "ABC" then i need to continue the job ahead else i need to abort the job. For my job the system name will be given as input parameter. i.t if paramater value entered as "ABC" tha value should be there ...

Hi,

My requirement is if the input parameter value which i give to the job is invalid then I need to abort the job.
Can any body tell me how to abort the job.
I don't want to use Sequencer for this?

Thanks,
Pramod.

I tried doing Hash partitioning on ID coloumn still showing wrong results.

I just took the auto option for ID coloumn.
MY problem is with the amount field lenth and data type.

OddJob wrote:Can you detail the sort and partitioning you're applying?

For each run i am getting different values like as follows
ID AMOUNT(15,2)
10 150
20 140
30 0
or
ID AMOUNT(15,2)
10 -150
20 140
30 -45

OddJob wrote:What values did you actually receive?

Hi, In my input data i have amount coloumn as data type Decimal(15,2). the amount may contain either +'ve or -'ve values. When I am trying to sum up the amount coloumn using aggregator first it raised up warning saying precesion exceeding. so that i have changed the data type from decimal to double ...

Thanks Minhajuddin it is working.

ppavani_km wrote:I have the input coloumn data as 24100.500,I need to change this coloumn as 24100 i.e i need to get only the characters that are before . symbol.can any body tell me what string function do we need use to get this.

I have the input coloumn data as 24100.500,I need to change this coloumn as 24100 i.e i need to get only the characters that are before . symbol.can any body tell me what string function do we need use to get this.

Can anybody suggest me what is a prototyping document in DS?
Can anybody suggest any template hw to do it?