Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Functions that checks specific values exists on DB

Functions that checks specific values exists on DB 3 years 4 months ago #15021

  • Harry
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 12
  • Thank you received: 0
I need to know on validation functions that has capability of looking up up values on a DB or File.

Harry

Please Log in or Create an account to join the conversation.

Functions that checks specific values exists on DB 3 years 4 months ago #15022

The following functions should be able to help your concern.

(1) IS IN LIST function, used to check if value exists in the database or file. Using this function however, may require significant amount of time to complete. Sometimes the result of the validation may be too big to handle into the memory.

(2) IS VALUE ON DATABASE and IF VALUE ON DATABASE are both better alternative. The way it works is very simple: during execution <value> is replaced with actual value If number of records returned is more than zero it returns success otherwise failure.



.

Please Log in or Create an account to join the conversation.

Functions that checks specific values exists on DB 1 year 11 months ago #17240

Hi Guys:

I'm need to correct a field with the value that is in database. Like this:

Select name From Cities Where SoundEx(Cities.name) = SoundEx(<value>) ;

I try ti use a If Value In Database Properties but this function only return number of records (is it correct??). In my case I'm need a field return.

Any help?

Thanks

Please Log in or Create an account to join the conversation.

Functions that checks specific values exists on DB 1 year 11 months ago #17241

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7617
  • Karma: 33
  • Thank you received: 419
You can use lookup transformation for it it would be the fastest option
www.etl-tools.com/wiki/aetle/transformation_functions/lookups
Or you can use SQL lookup
Mike

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 201 guests and one member online