Hi, finally we got the solution... it was a bug in the database.
Now my job loads the correct number of records
Thanks for your suggestions
Search found 3 matches
- Mon Apr 14, 2014 10:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inserts more records than the source has
- Replies: 8
- Views: 5925
- Wed Mar 26, 2014 7:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inserts more records than the source has
- Replies: 8
- Views: 5925
Hi Ray! Thanks for your answer, Yes.. its the same DB and schema and table The log reports 21138554 records and its the same inserted in the target Netezza. Here I put some of the Log lines The connector was configured to run in parallel mode on 2 nodes, but the partitioned reads were not enabled. T...
- Wed Mar 26, 2014 4:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inserts more records than the source has
- Replies: 8
- Views: 5925
Inserts more records than the source has
Hi, I hope someone could help me I have a parallel job that extracts from a Oracle Table and inserts into Netezza Table But if I put the query Select count(*) from ( select field1,field2...fieldn from schema.table ) then a click "view data" in the Stage "Oracle Connector" The res...