Data view is returning "Data Source is empty"

pxraja · Post by **pxraja** » Fri Aug 01, 2008 6:34 am

I had extracted the data from sqlserver through Odbc stage and transformed to Oracle database table through transformer to another Odbc stage, Its a straight pull from source. 7 lakhs records has transferred to oracle table with the following warning for 10 columns

SQLColAttributes(Field1) gave MetaData mismatch
MetaData mismatch on COLUMN.SCALE Expected = 3 Actual = 0

Problem is when I try to view the data from designer window. the data browser is reporting a message as "Data source is empty" and closed.

whereas i can view the data from the oracle table by querying all the 7 lakhs record.

anyone can help me to resolve this problem.

Thanks in Advance

chulett · Post by **chulett** » Fri Aug 01, 2008 6:59 am

Viewing data from the target side is a little bit of a different animal as there's no "select" query in the stage for it to use. What is your "update action"?

ray.wurlod · Post by **ray.wurlod** » Fri Aug 01, 2008 8:07 am

Get rid of the metadata mismatch (the Scale figure for Field1) then see if View Data is effective.