I have created a datasource of type Database and given an sql query which is fetching some of the decimal data.
But when I am checking preview for the sql query, it is showing integer data (rouding off the decimal value) even though the field type is coming as double.
Please let me know how to resolve this issue.
Are you mapping your datasource to a view? -- If so, this may be due to a known issue caused by jdbc. Way to work around it is to use a table instead of a view, with number columns defined with explicit precision, as in NUMBER(10,2).