cancel
Showing results for 
Search instead for 
Did you mean: 

BODS query transform generated too many records

former_member280200
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member208402
Active Contributor
0 Kudos

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.