on 01-25-2017 6:35 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.