Hi,

I am trying to load a table from a flat file. Table has create timestamp and update timestamp columns which I want to populate with current timestamp.

How do I need to create a input flat file. I dont want to give timestamp in input. It should be automatically populated while loading table.


Please suggest.



Thanks & Regards
Mandar Panse

Define the two timestamp columns with the default value of current_timestamp, then omit these columns from the load command. They will be populated with the default value.