I need your help to know if FDM store values in database which gets exported in the target applications. If at all FDM stores the values at export stage in the database then please let me know which table to look at for the export stage values.

I see values in the database tables which are imported in FDM but after the validation and export steps I am not able to find the export level values in the database.

All data is stored in the tDataSeg tables in the FDM database i.e. the same table that stores your imported data will also store the data that is exported (the transformed/mapped values). Those values are stored on the same data row in Columns suffixed with X. Therefore the target Account member would be stored in the AccountX column, Target Entity in EntityX etc

Actually, I wanted to see the amount that is exported, but when I cheked the AmountX column in tdataseg table I didnt find any values in that field. Is there any table field where I can find the amount that gets exported.

The amount is in the amount column as usually it is the one value that remains untransformed from import to export. Also bear in mind that when the data is exported it will do a Aggregation of all amounts where the target intersection is the same