DSXchange

Hi,


The column B is mentioned as Number datatype in oracle table without length.

I donot mean that.
sorry for mentioning it.

Hi all i am getting the below error from the oracle query used. floating point decimal is not fully supported; adjusting the scale. Ora query used. SELECT DECODE(FN.column A,NULL,'NULL',FN.column A) AS column A, SUM(CAST(FN.column B AS DECIMAL(38,10))) AS column B FROM Table FN WHERE FN.DATE=to_date...

Thanks a lot

Iam able to get required output

Thanks a lot

Iam able to get required output

How to limit the output to the first 5 rows

I getting the data as below column A Column B 1 20.9 2 10.8 3 27.4 4 15.3 5 32.1 6 15.7 Output to be generted only for top five column B values in descending order Coumn a Column B 5 32.1 3 27.4 1 20.9 6 15.7 4 15.3 Please help me out .

It is to populate five largest decimal values.

Hi all

I have need to populate top five decimal values after doing validations for which i have used transformer stage.

Pleae share how do handle this .

Thanks in advance

use Trim function
Trim(cloumnname,'0','L')

It will trim leading zeros

Thanks Ray.

i will try with that.

Is there any option without going for reject link in lookup stage .

Hi All,

how to capture unmatched records after doing reference with database .

could you please help this

Thanks in Adavance

Thanks.

This is the part of tuning at the source level for the file. and how to improve the performance while it is inserting into the target table which is oracle as it is taking the long time

hi,

Could you please tell me how set the readers option and where can i find it