DSXchange

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

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"?

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