Thanks Knicely. If I try by enclosed by '"' some records are inserting into table but again I got some rejected records. Saying two many column found. Data is like 1,"Adaptor, PCI-4x, LAN, 17"" 1000Base-TX",My Test So what should I do for loading this data. If u have any solution with replacing the ...

see tha column 7 from last has " and ,

becuase of this i am getting exception To Many Columns Found and the record has been rejected. what i want is, i want to load the data by removing this " and , from that columns if it is not possible to load the original data.

Hi Guys, i am using .csv file to load data. it has data like 2013Q2,201306,Asia Pacific,Asia Pacific Countri,Japan,Japan,Japan,Japan Local Sales,R700,PSG Support,Ongoing Renewals,Ongoing Renewals,O,Indirect,HPS SAP PJ1 APJ,,,,N/V,N/V,N/V,5X,5X,A8685A,"Adaptor, PCI-4x, LAN, 1000Base-TX",?,N/V,N/V,JP6...

HI all i have two tables . both are having references. i need to update one table bye joining those two common columns. first table has 4crors of data and second one 1.5 crors of data i had written a query update table_name set column_name=(select column_name from table_name2 where table_name2.match...

Hi all when i am executing sql query in unix with vsql command, i am getting error like error is: use utf-8 locale not roman8 locale. why i am getting this error, what would be the solution to overcome this. !# /bin/ksh exec_vsql=/app/informatica/infa_drivers/vertica/opt/vertica/bin/vsql $exec_vsql ...

hi all, i have a problem in loading data into the vertica database with informatica tool. i have some special charecters in sql server in description and subject columns. data type for these columns are nvarchar. data presents in sql server is like this "Sehr geehrte Damen un Herren, hiermit bestäti...

hi all, i need to check that, not null records in all columns. for single column we can write query like select *from table_name where not is null (id); if i have 10 columns and i need to retrive records those are not having null in all columns. please give me query for this. thanks in advance.