Problem - You have a job to transfer data from source table to target table and you are using some talend input and output database components for example tMSSqlInput and tMSSqloutput. You are interested in finding the rejected rows which are not processed by your tMSSqloutput component
Solution - For this you can use ROWS-->REJECT property of tMSSqlOutput component. Right click on tMSSqlOutput and select Rows-->Reject and then connect this reject flow to your other tFileOutputDelimited component or similar.
(Validated on TIS V 4.0.2)
Solution - For this you can use ROWS-->REJECT property of tMSSqlOutput component. Right click on tMSSqlOutput and select Rows-->Reject and then connect this reject flow to your other tFileOutputDelimited component or similar.
(Validated on TIS V 4.0.2)
Not valid on TDQ 4.2.3
ReplyDeleteAre there any conditions that this relies upon? Are there any penalties in using it?
ReplyDeleteI.e., when using Oracle output, the Use Batch option under the Advanced tab HAS to be UNCHECKED, otherwise, REJECTS as an option does not even appear.
When using REJECTS, there can be signigicant performance decreases. In an informal test, I got a 120x difference between using REJECTS and not.
i want to create user define sequence in talend it's possible ?
ReplyDeleteHi , I want to remove empty rows from the mandatory column and log into a file. How i can do that
ReplyDeletethanks Anonymous from 7 Jan :) same rules applied to PostgreSQL output, reject row doesn't appear until Batch option and Dien on Error are unchecked.
ReplyDelete