Load Ingest Data
Results 1 to 2 of 2

Thread: Data Type Determination

  1. #1
    SumOfDavid is offline Junior Member
    Join Date
    Mar 2015
    Posts
    1
    Rep Power
    0

    Question Data Type Determination

    I have an Oracle source and SQL Server target. How does Attunity determine what SQL Server data type to create? I've noticed that an Oracle NUMBER(8,0) might be created as an int, numeric(38,0), or other data types. Is there some sort of analysis done of the data?

    We're running into the issue where the Oracle production & test data types are the same, but the SQL Server production & test data types are different.

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    297
    Rep Power
    6
    Hello SumofDavid,

    Please refer to the User Guide on how Attunity Replicate Mapping Data Types for Oracle and SQL.

    Also, you can change the datatype from the transformation of the tables from the task design.

    Thanks,
    Steve

Posting Permissions

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