Skip to Content

Data validation routines in BODS

Hi,

What is the Data validation routines in bods. how to write and where it use..

Regards

Srini

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 24, 2014 at 03:06 PM

    'Validation routines' can be developed with custom function.I hope this is what you are looking for.

    Magesh


    Val_function.JPG (68.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member srini srinivas

      Hi,

      Just below custom functions you have validation functions.

      You can create new validation functions similar to custom functions and call these in validation transform (While adding validations in rule editor).

      Typical examples all to validate data based on some rules and return flags 0 or 1. You just need to call this function in validation transform's Rule Editor.

      Hope this helps.

      Thanks

      Shesha

  • Jan 08, 2015 at 09:14 PM

    Hi

    For data validation in a dataflow you can use the Validation transform. In the Validation transform there are validation options including using a validation function where the custom functions defined as validation function will come in handy.

    Depending on your requirement there are a different ways to validate data. Do provide more details on where you are intending to perform validation in your job.

    kind regards

    Raghu

    Add comment
    10|10000 characters needed characters exceeded