Skip to Content
avatar image
Former Member

Value Mapping - size limit

Hi all,

We got a doubt regarding value mapping,

Is there any size limit for value mapping tables that we are creating in Configuration?

Thanks and regards,

sasi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    Jan 16, 2009 at 09:13 PM

    Hi,

    since the valueMapping will be executed on Java Stack, the size limit will rely on your JVM memory setting (Heap size, basically).

    But the memory request will be from your payload. As a rule of thumb, the memory requirement will be 5-10 times of your payload size.

    Cheers,

    Aaron

    Add comment
    10|10000 characters needed characters exceeded

    • I think he means the total table size, not the number of entries per execution.

      I'd say it depends on your DB installation.

      You have to size it according to your expectations, or else you'll eventually get a tablespace overflow.

      Regards,

      Henrique.

  • Jan 16, 2009 at 08:43 AM

    I am sure there will be a size limit. But not sure if it is documented anywhere.

    Did u try to mock various values in the table and test the limit?

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 16, 2009 at 08:54 AM

    This should be based on the XI server configuration like Phys_mem. I dont think if there is any standard limit.

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2009 at 09:06 AM

    Hi,

    When you Create an Value mapping The size of the target element depends on the Type of data type you mention for the element in the Target Size.

    I Personally feel the Size Limit Depends on the Data type used on target Field

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2009 at 10:31 AM

    We didnt tried giving different values.But as per our client requirement we are in a situation to maintain value mapping tables of large size. So it will be of great help if any documents or links that says about value mapping size.

    Thanks and Regards

    Sasi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 19, 2009 at 09:33 AM

    hi all,

    Thanks for the reply,

    What our doubt is ...is ther any size limit to load values in Value mapping table while doing configuration in ID.

    I am not asking size limit for runtime execution of value mapping.

    Add comment
    10|10000 characters needed characters exceeded