Only 1st column in tMap CSV file valued for constraint

[Anonymous]

Hello,

Thanks for your help in advance.

I'm having an issue where only the 1st column of my CSV file is being considered for constraints.

I've setup tMap (attached) to pick up erroneous rows and reject them into a Reject.CSV file.

When the job is run and a constraint column other than column 1 is found, it gives me an Oracle error.

Not sure why the tMap isn't picking up other columns.  Please see attached.

Thanks

[Anonymous]

@manodwhb Talend Open Studio for Data Integration

[manodwhb]

OK. What is your constraint ,on how many columns it is there?

[manodwhb]

check the below link will help you how enable filter for the output and get reject data from tmap.
https://subscription.packtpub.com/book/big_data_and_business_intelligence/9781782167266/3/ch03lvl1se...

[Anonymous]

@manodwhb thanks for the link.  This will filter based on the source CSV data and tMap would filter based on its own rules.  However, I was hoping to have all rejects which were denied entry into the Oracle table including incorrect data type, incorrect data format, etc...

[manodwhb · Accepted solution]

Since you're using open studio you need to do manual check only.

[Anonymous]

@manodwhb Thanks for your help.  It seems Oracle tDB output is the culprit as other outputs do have the reject option.  Nevertheless, thanks for your time!