How to handle column names with space in between
810928Nov 16 2010 — edited Dec 30 2010I have a requirement where in I am writing the output of one query into a table. The query is returning a resultset which has space in the column name for ex -
select DT_LOC "*Date A*" , COL1, COL2 "*Column Name*" from TABLE
I am trying to write the output of above query into table B which has similar structure using a stored procedure. My source has the above query, where as target has the insert statement as below -
insert into TABLEB values ( #"Date A" , #COL1, #"Column Name")
or
insert into TABLEB values ( "#Date A" , #COL1, "#Column Name")
ODI is not able to handle the column name with space in between i.e. Date A & Column Name. Note - I can not map these tables as models as they can change dynamically.