-
Migrating Data from csv to staging table
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 Table..it doesnt do so..Kindly suggest me should I need to declare some function in CTL For date or sumthing else.
Himanshu
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|