Where to find or How to create LKM SQL TO SQL ?
907160Dec 23 2011 — edited Dec 26 2011Hi,
I m very much new to ODI.
My problem is I've to map a table in my ORACLE DB to a CSV file. So I've created an Interface in my ODI editor and
1. Checked "Staging area different from Target".
2. Now it is saying " Staging area is different from the target. In order to load data from the staging area to the target, you should select a multi-connection IKM on the target or a LKM on the staging area."
3. In my target i am using an IKM SQL Control Append
Can anyone tell
1. How to make this "IKM SQL Control Append" as multi connection
or
2. Which LKM should i use for my Staging area. And where can i find that LKM. ( Right now i only have LKM Sql to File which i got from some previous project.)
Thanks in advance :)
Vikas.