Hi ,
We have csv flat file which has year in YY format and but the destination tables need it in YYYY format. We are using IDM for the data load .

Does YTHRESH and DEFCENT work for iDM


Please clarify ?



-Thanks,
Geetha

This message has been edited. Last edited by: <Kathryn Henning>,

Seems like this is something that could be tested fairly easily using SET TESTDATE.

Hi,

This resolved my issue. Thank you