02/08/2023 04:19 AM - edited 02/08/2023 04:20 AM
We are trying to perform incremental import from authoritative source (SQL database) and have two queries related to the same:
1. We need to know the format of the "updatedate" column in the DB table/view. In the documentation portal it is mentioned as yyy-mm-dd hh:mm:ss.0 (3 y's for year) but it seems not correct, could you please confirm the if the format should be yyyy-mm-dd hh:mm:ss.0(4 y's for year).
2. Do the column name in the Databse table need to be "updatedate" only or it can be any other name as well like "Last update timestamp"?
Solved! Go to Solution.
02/08/2023 04:33 AM
target column name should be updatedate (know defect )
its typo it should be 4 y @uthra_rahul
02/08/2023 04:55 AM
02/08/2023 04:56 AM
02/08/2023 08:41 AM