Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
TDATASEG_T vs TDATASEG table FDMEE
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
Best 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.
Answers
-
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.
-
So the data in see in workbench is stored in table TDATASEG
Regards
-
-
Thanks for help.
Regards