Discussions
Categories
- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.7K On-Premises Infrastructure
- 137.8K Analytics Software
- 38.5K Application Development Software
- 5.4K Cloud Platform
- 109.2K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.9K Infrastructure Software
- 105.1K Integration
- 41.5K 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