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
Data view is returning "Data Source is empty"
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: