Forum Stats

  • 3,769,310 Users
  • 2,252,947 Discussions
  • 7,874,983 Comments

Discussions

FDMEE 11.2.4 imports rounded off data from Source.

When importing data from source, FDMEE imports rounded off data from the source. For example, if the data in source is 255.8192, it is getting imported as 256.

We need the data to be imported as it is from source. Are there any settings in either FDMEE or ODI that is causing this behavior? Has anyone faced similar behavior and fixed it?

Best Answer

  • msesudos
    msesudos Member Posts: 32 Red Ribbon
    Accepted Answer

    This issue is resolved. Issue was caused due to incorrect data type in the "GenericSQL" logical architecture. After migration of ODI packages, it was found that below data type was present.

    Logical Architecture -> GenericSQL -> Data Types -> DECIMAL (open decimal datatype) -> Converted to -> SAP HANA (technology) -> <Undefined> data type

    It was modified to as below

    Logical Architecture -> GenericSQL -> Data Types -> DECIMAL (open decimal datatype) -> Converted to -> SAP HANA (technology) -> DECIMAL

    After the above change, regenerated ODI scenario. This helped to resolve the issue. After the change, data now gets imported correctly with decimal digits.

Answers

  • msesudos
    msesudos Member Posts: 32 Red Ribbon

    Adding to my previous comments, source system is SAP HANA. We are using UDA adapter to connect to SAP HANA to pull the data.

    I checked in TDATASEG table and I could find entries in AMOUNT and AMOUNTX column in TDATASEG table has data with correct precision (actual data without any rounding off) but for some reason the data displayed in Data Load workbench is a rounded off one.

    Any suggestions are highly appreciated.

  • msesudos
    msesudos Member Posts: 32 Red Ribbon

    Correction to my previous update - Data present in the TDATASEG and TDATASEG_T tables are also rounded off data only which is getting displayed in Data Load Workbench.

    I believe the data round off is happening while importing it from the source itself. We are using UDA connection to connect to source SAP system. Any pointers whether any setting/mapping in ODI needs to be reviewed for this?

  • msesudos
    msesudos Member Posts: 32 Red Ribbon
    Accepted Answer

    This issue is resolved. Issue was caused due to incorrect data type in the "GenericSQL" logical architecture. After migration of ODI packages, it was found that below data type was present.

    Logical Architecture -> GenericSQL -> Data Types -> DECIMAL (open decimal datatype) -> Converted to -> SAP HANA (technology) -> <Undefined> data type

    It was modified to as below

    Logical Architecture -> GenericSQL -> Data Types -> DECIMAL (open decimal datatype) -> Converted to -> SAP HANA (technology) -> DECIMAL

    After the above change, regenerated ODI scenario. This helped to resolve the issue. After the change, data now gets imported correctly with decimal digits.