Forum Stats

  • 3,770,233 Users
  • 2,253,082 Discussions
  • 7,875,370 Comments

Discussions

TDATASEG_T vs TDATASEG table FDMEE

JanGLi
JanGLi Member Posts: 649 Bronze Badge
edited Sep 23, 2016 12:31PM in Financial Data Management

Hi,

Oracle Documentation says that this is the staging table TDATASEG_T but i can't see any data in this table. Instead i can see data in this table TDATASEG_T.

Why is that?


Regards

Tagged:
ThinkFDM

Best Answer

  • SH_INT
    SH_INT Member Posts: 3,188 Bronze Crown
    edited Sep 22, 2016 11:19AM Accepted Answer

    TDATASEG_T is a staging table used during the import phase of the workflow. Data is stored in the table temporarily while the import and its transformations are being processed. On a successful import the records are transfered to the TDATASEG table which is the main data table.  This will be why you don't see in any records in the TDATASEG_T table because by design they are not meant to persist there.

    ThinkFDM

Answers

This discussion has been closed.