Skip to Content

Loading only few records

Hi All,


I need help in resolving this issue.
Source : DB2 Target : DB2
Trying to load 1.9 million records to target table but it is loading only ~.5 million.

Data Flow : sql >> qt>> qt >> key generation >> Target table ( Bulk loader: CLI Load, Mode: Insert )

Not sure why it is missing records. Please advice.pic1.png

pic1.png (15.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Mar 25 at 02:04 PM
    1. What does your SQL statement look like? Does it contain any inner joins?
    2. Any filters in your Query transforms?
    Add comment
    10|10000 characters needed characters exceeded