ODI - Topology steps and model creations

 Step1: Create Repository connection

Step2: Go to Physical architecrure and choose 1 technology for example Oracle and new data server.

Step3: provide db connection details

Step4: provide jdbc details.

Step5: right click on the created data server and create new physical schema.

Step6:provide schema and work schema details. Context part we have to do once we created the logical schema.

Step7: Create context

Step8: create new logical schema

Step9: and map context to physical schema

Step10: Now go to design and tab create new model based on logical schema. And reverse enggineer to get all the datastores.