DSXchange

I get that Franklin as I've already mentioned. My question here is whether this is something that CAN be handled in a transformer and if yes, how?

I know I have to account for the Sign and the Decimal as I've already mention in my post. The actual number of digits don't seem to matter. Whether I pass 500 or 1234567890 , the result remains the same. Decimal(10,0) will just not enter varchar(10) without 1. Using a cast and converting it at the s...

Sure

Yes Craig. I tried using the DecimalToString() function but it throws a conversion error and outputs a blank value. Ditto if I increase the target length by 1. But if I make the target length varchar(12), the data loads fine. I assume this is because a decimal outputs 2 additional characters - one f...

Hi All, I am trying to convert a source column with data type -DECIMAL(10) to VARCHAR(10). I realise that this would result in conversion errors since the target length would have to account for the sign and the decimal point in the source. I'm currently implementing this by converting the datatype ...

No. Highly doubt that

A UNIX script may be? And then you can use the "External Source' to read the data.

It should perhaps be subtracting the number of days in the month the specified date is in. So if the date is May 20, it should subtract 31 days and if the date is June 12, then it should subtract 30 days. If the date is in February, it should subtract 28/29 days depending on the year of date.Your th...

BigInt not an option since we have decimal values coming in. Have already implemented with if-then-else. Just wanted to know if there's a more easy-on-the-eye solution. Parallel Routine may be?

Hi All, I've been trying to use the MIN function in the parallel transformer to find the minimum between two decimal values but always got an error citing that the decimal value is out of range. I realised, after some searching, that the output of the MIN function is an integer. Is there a straightf...

I would want it to take me to the last day of the last month. ie. If my business date is 2013-03-31, then the output should be 2013-02-28. If 2013-03-30, then 2013-02-27.

Dear All, I've formulated a few derivations to calculate certain dates (Listed in BOLD). If your time dimension cannot help or you don't have a time dimension, the following might help. Feel free to add or optimize my derivations. This thread can be a handy reference for many. Last Day of 2nd Last M...

I expected it to return a date that would ideally be in the month of february. I find it difficult to comprehend the rationale behind why the function would be designed to work the way you think it actually is.

I've been playing around with the DateOffsetByComponents() function to implement one of our business requirements. However, the function seems to be returning incorrect values. Either that or my understanding is wrong. DateOffsetByComponents("2013-03-31",0,-1,0 returns 2013-03-03. Any idea...

Once again, why not try doing it all in the query? SELECT SUM(AMT) OVER (PARTITION BY ID ORDER BY CODE) FROM TABNAME ought to give you the expected result in fairly quick time. OLAP functions provided by database vendors are very efficient and if you have the choice, go ahead and use them. We had a ...