I'm trying to load a target table from the source table (both in Oracle DB)
In the source table there is a column named "comment". As this is an Oracle keyword, while running the job, I'm getting the error: "SourceTable"."Comment" Invalid identifier.
The Create table statement uses double quotes for specifying the column name ("COMMENT"), but still in BODS Im getting the error.
can anyone please help to resolve it.
Thanks in Advance