This content has been marked as final. Show 2 replies
Yes data is always exported to a .dat as that is the default action of the Export Action script for all of the current adapters. Data isn't exported to the RDBMS at this point it is the data contained in the FDM database that is being exported to a file. FDM stores all data processed in a series of tables called tDataSeg n where n is an incremental number. Each location has is own dedicated tDataSeg table. You can find out which one by checking the DataSeg table id associated with the location in the tPOVPartition table. As I previously mentioned the tDataSeg tables store all processed data for the location hich includes both the original source values brought in at the import stage and the transformed/mapped values once the mapping table logic has been applied. If you are looking to inport data into a data warehouse I suggest you use the flat file output in the Outbox as your source not the underlying FDM tables, the file is easy to understand and requires no knowledge of the underlying FDM tables and will be constant if even if the architecture of the FDM database was to undergo redesign in future releases.