Feed structure validation

[kpmINFO]

Hi ,

I need to know if we can achieve this in informatica wherein i get flat file and i need to validate the feed structure and only process if it's according to valid feed structure , please give me atleast some inputs as to how to proceed on this..

 

[blom0344]

What do you mean with 'Feed structure'?

T. Blom
Information analyst
tbl@shimano-eu.com

 

[kpmINFO]

I mean in my specific source flat file
0012312 234 Asdee 322 12112 H874 B888 99900 UD

1st level validation would be to check if there are numbers coming in 0012312 place say if i get literals like aaabb something it should reject this data , second level validation would be to check 0012312 corresponds to correct acct number as such, please walk me thru if anybody has did something like this before

 

[blom0344]

Look into the Is_Number test function to parse if you have a numeric value.....

T. Blom
Information analyst
tbl@shimano-eu.com

 

[vln]

The First step would be to use a isnumber fuction in an expression & check whether the incoming data is valid accord. to your constraint(Like Numbers only).

Then in a lookup transformation check whether the incoming number is valid account number.

I think this would serve your purpose.

 

[mpcurry]

Hi vln,

What if it is not a valid number and I want to reject that record with an error message in the session log.

Regards.