Skip to Content

BODS query transform generated too many records

Hi Everyone,

We are having a really strange problem with DS and was wonderring if anyone has came across this problem?

We are using Data Services at our current project - DS 4.2 on Linux with Sybase (16.0) as our Database. We have a job where we are removing leading zeros from some of our columns, the job consists of a Source table, a query transform and a Target table. Both tables reside in the same Sybase database:

SOURCE TABLE --> QUERY TRANSFORM --> TARGET TABLE

The Source table contains only 2,322 records (I double checked the count), however after we ran the job we ended up with 5,391,684 records. It looks like each record in the source table exploded to 2,322 in the target table - 2,322 X 2,322 = 5,391,684. I have double/triple checked the dataflow and did a count on the source table to make sure I didn't overlooked anything, I also re-ran the job multiple time and still can't find out why I am getting more than 2,322 records. In all my years using this tool, I have never came across a problem like this.

Does anyone have any idea where I can start looking?

TIA

Lynne

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 26, 2017 at 06:41 AM

    Can you please post picture of Query transform here and also try creating same data flow again with flat file as a source and check if this is the problem with DS or with the database.

    Add comment
    10|10000 characters needed characters exceeded