Validating Records Fetched From Stored Procedure

Seven Stars

Validating Records Fetched From Stored Procedure

Hi,

 

I am fetching some records (approx. 10 in count) using stored procedure and I need to validate these records one by one.

Here is the requirement regarding validating these records.

 

  1. Each Record will contain following fields

           FirstName, Last Name and Email

    2.   Following Validation to Be applied on all these 3 fields

  • First Name should not be blank and First Name should not more 25 characters
  • Last Name should not be be blank and Last Name should not more 25 characters
  • Email should not be blank and be valid email

 

Once each of these records passes these validations then we need to process these records one by one.

Records which don't pass these validations need to be logged in separate table and mail will be send for them.

Is it possible to apply these validations on the records using Talend ODI? If yes please help me with this.

 

Regards

Tarunjit Singh

Thirteen Stars

Re: Validating Records Fetched From Stored Procedure

You need to use tMap after feacthing from procedure.
in tmap you need write expersions in Active/unactive expresion filter

procedure-->tMap-->target
Manohar B
Forteen Stars TRF
Forteen Stars

Re: Validating Records Fetched From Stored Procedure

Hi,
tFilterRow is here for that.
You can achieve all these controls with basic conditions except for email validation.
For email validation you need to write your own routine (many examples on Google) then call this routine using the tFilterRow Advanced more.
In my opinion this approach is much more better than the tMap approach as when you open the job you can immediatly see that you have filter conditions for your flow (think maintainability).

TRF
Forteen Stars TRF
Forteen Stars

Re: Validating Records Fetched From Stored Procedure

Does this help?

If so please mark this case as solved (Kudos also accepted).


TRF