APPEND Mode + Insert statement
Hi All,
We are using Informatica to load data from one schema to another schema. Both schemas are in same server. Our source qualifier query is tuined enough, but problem is while loading data into target table. As per receommendations from DBA, we need to use APPEND hints in INSERT statement. But we do not have control over Intert statement as Informatica generates Insert statement during load.
My question is, is there any variable by which we can alter session, so that, for any Insert statement, oracle load data into table with APPEND mode?
I hope i m clear on my requirement. :)