I had to create new date format like YYYYMMDDHHMISS . so i created in the following way.
other = '%Y%0m%0d %0H:%0M:%0S' (datatype=datetime);
I got successed to create a New date format. but now i also have to create informat YYYYMMDDHHMISS.
but some one told me using picture stament i can't create INFORMAT.
so my first question to you that
1) while creating DI studio Job, Informat play a important role?. If No, then Can we put Informat of Date Column as NONE?.If I put it as NONE then in future will it not create problem while using this data set with another one?.
2)if YES, then How can i create a New date Format/Informat using Value / Invalue statment.