Pages: 1

Post reply

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » I'm a fresh for talend tool. Do not understand why the reject not work

#1 2012-04-27 08:06:39

PETER_LG
Member
Registered: 2012-04-24
Posts: 41

I'm a fresh for talend tool. Do not understand why the reject not work

Tags: [bug, development, error, error management, mssql, schema]

HI Everyone,

I need your kindly help. I'm a fresh for the talend tool. I just start to try to use this tool from yesterday, and do not understand why the reject does not work as expected, please help, maybe I do misunderstand the reject function? please help.

One simple flow, tMSSqlInput ---> tMSSqlOutput, one field in schema of tMSSqlInput allows null but does not allow null in schema of tMSSqlOutput, i guess that if has records which the field is null, the records of the field with null value should be output through the reject ... but does not work ...

Row reject of tMSSqlOutput ....

thank you.


Uploaded Images

Last edited by PETER_LG (2012-04-27 08:08:38)

Offline

#2 2012-04-27 08:14:20

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: I'm a fresh for talend tool. Do not understand why the reject not work

Hi

Welcome to Talend Community!

According to your description, you can add tFilterRow between tMSSqlInput and tMSSqlOutput.

Regards,
Pedro

Only Paranoid Survive.

Offline

#3 2012-04-27 08:59:54

PETER_LG
Member
Registered: 2012-04-24
Posts: 41

Re: I'm a fresh for talend tool. Do not understand why the reject not work

Pedro, thank you.

So can I know what the [Reject] is used for? thank you.


Uploaded Images

Offline

#4 2012-04-27 09:20:30

PETER_LG
Member
Registered: 2012-04-24
Posts: 41

Re: I'm a fresh for talend tool. Do not understand why the reject not work

Version: 5.0.2
Build id: r78327-20120216-0244

You could see the option when below 2 scenarios (Please see attached snapshots), thank you.


Uploaded Images

Offline

#5 2012-04-27 09:43:47

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: I'm a fresh for talend tool. Do not understand why the reject not work

Hi

Sorry. My fault.

According to your description, I think tFilterRow is more useful for checking null rows.
The reject of tMSSQLOutput will send error rows(e.g. Data truncate error). But for un-checking 'nullable', it doesn't return error.

Regards,
Pedro

Only Paranoid Survive.

Offline

#6 2012-04-27 10:20:42

PETER_LG
Member
Registered: 2012-04-24
Posts: 41

Re: I'm a fresh for talend tool. Do not understand why the reject not work

Hi Pedro,

I tried it, you're right. Yes, it can do the [Data truncate error]. Thank you very much.


Peter.

Offline

Post reply

Pages: 1

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » I'm a fresh for talend tool. Do not understand why the reject not work

Board footer

Powered by FluxBB