Skip to Content
0

BODS query transform generated too many records

Jan 25, 2017 at 06:35 PM

50

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ravi kiran Pagidi Jan 26, 2017 at 06:41 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded