Pages: 1

Post reply

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Manage/Avoid duplicate row into a tMSSqlSP

#1 2009-08-27 13:54:29

brasco06
New member
Registered: 2009-08-25
Posts: 3

Manage/Avoid duplicate row into a tMSSqlSP

Tags: [duplicate, sp]

Hi,

I'm using a tMSSqlSP who call a stocked procedure. When the procedure detect duplcate rows, it stop and doesn't go to the next row.
Is there a way to manage that ? If a duplicate row is detected, I just want to avoid id and to go to the next row.

Regards,

Sam

Offline

#2 2009-08-27 18:02:57

nkxxDV
Member
Registered: 2009-07-20
Posts: 31

Re: Manage/Avoid duplicate row into a tMSSqlSP

tUniqueRow is made for this isn't it ?

This would only be a problem if you had a lot of data, as this component loads every row in memory.
Then you'd have to find a workaround ...

Offline

#3 2009-08-28 08:00:54

shong
Talend team
Registered: 2007-08-29
Posts: 10297
Website

Re: Manage/Avoid duplicate row into a tMSSqlSP

Hello Sam
As nkxxDV said, you can use the tUniqueRow before tMssqlsp, it will filter the duplicate rows and only transform the unique rows to tMssqlsp.

Best regards

         shong

Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

Post reply

Pages: 1

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Manage/Avoid duplicate row into a tMSSqlSP

Board footer

Powered by FluxBB