The contents of the CSV file is as shown:
LOAD DATE,30-Nov-15
STORE,MANAGER NAME,PHONE Number
519900,STEVEN FRENCH,905-271-3644
520300,IAN MCGAUGHEY,519-672-9986
512400,,416-665-4657
512900,RAKESH PRASAD,905-672-6301
I want to add 30-Nov-15 to a column of table1 and
519900,STEVEN FRENCH,905-271-3644
520300,IAN MCGAUGHEY,519-672-9986
512400,,416-665-4657
512900,RAKESH PRASAD,905-672-6301
to 3 columns of table2 using a single CTL file. Please help.