In my staging table i have column as Effect_Date as Date its data type.
I have one Flat file separated by '|' .And one of the column contains Date in the format '21-JAN-08 12:30:54'.When ever I m runninng CTL file to load data into Staging doesnt do so..Kindly suggest me should I need to declare some function in CTL For date or sumthing else.