Number validation

[kpmINFO]

I have flat file which has to be loaded into oracle DB using informatica. I have a number data type column in the database, now when I transfer the data from flat file into the database I need to check if the specific column has a number, instead of a number if there is some kind of character or a string I have to reject that row. Can someone give me how I can achieve this. My concern is, within informatica transformation if I declare a port as number and if it receives a char or sting, how would informatica handle this , will informatica triggers a error and stop the session?
Before I would like to know How can I achieve this kind of check in informatica?

 

[blom0344]

Look into designer's standards functions. There is perfectly suited test-function available that is called:

Is_Number()

It will return a 1 for a valid number and 0 otherwise .....


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