Yes Topology is there.
Do you think performence will be good with those KM's? or any known bugs in those KM's as iam using 10g.
How about using sqlunload and then load into oracle db?Do you think sqlunload will increase the performence?
You mean the Odi Tool SQL Unload that loads SQL results in a flat file ?
Yes, I think it's reliable.
But the main issue will be to load this file as fast as possible in your Oracle DB. And for that, you will have to use the SQLLDR or EXTERNAL TABLE functionnalities.
Step 1 : unload your AS400 SQL statement results into a flat file
Step 2 : create an interface that reads this file and load it in Oracle DB
Step 3 : compare with an interface that use LKM SQL to Oracle
Just one query regarding Agent,we have here AS/400 source Server and oracle db target server
Where we need to install agent? incase if i sqlunload and create file and load using sql loader what is the best place to install agent?
if we have one more server(not source and not target) and if we install agent there and unload files into that server, can we still load the files(across network) into oracle target db using sql loader from the server where agent installed?
install agent on TARGET server (= Oracle DB) and unload the data of DB2 in the form of files into FOLDER (which can be read by AGENT, why not in the same place than your Oracle DB) and load them using sqlloader(which again needs to be there on source server) using same agent,right?
You create a package that launch and SQL statement on DB2 database and unload it into a file.
Then, copy this file in a folder located in the same host than your Oracle DB.
Then launch an interface that use LKM SQL LOADER to load the file into an Oracle DB table.
Using the agent that is installed on the same host than your Oracle DB.
I think it's the best solution.
You can also use a shared folder between the 2 serveurs, but it's better if ODI will read the file directly on the agent host. And it's better if the agent host is located on the same server than your Oracle Database.