Results 1 to 2 of 2

Thread: Error: Value larger than specified precision allowed for this column - Informatica

  1. #1
    Senior Member
    Join Date
    Aug 2012
    Posts
    37,163

    Error: Value larger than specified precision allowed for this column - Informatica

    I am loading data from source into the target using the ETL tool informatica and getting the following error:

    Code:
    Value larger than specified precision allowed for this column
    The data which has the error in loading is 512345678919.

    For both the source and target, i have specified the same precision. Why this value is not loading into the target.

  2. #2
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514
    Check whether there are any transformations between the source and target, that has precision less than the source.

Similar Threads

  1. Informatica: Prev column value display
    By amrutha in forum Data Warehouse
    Replies: 0
    Last Post: 12-30-2012, 06:49 PM
  2. Concatenation Disallowed error in informatica
    By amrutha in forum Data Warehouse
    Replies: 0
    Last Post: 09-03-2012, 11:36 AM
  3. Aggregator Transformation Error - Informatica
    By vijay in forum Data Warehouse
    Replies: 1
    Last Post: 05-27-2012, 05:52 AM
  4. Replies: 3
    Last Post: 05-25-2012, 10:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •