Friday, October 8, 2021

ODI - Create Model and Topology objects using Wizard option

 Implementation steps: 

Step1: Go to Design tab and Models Accodian and click the folder sign and New Model and Topology Objects.


Step2: provide Model name, select technology , Logical Schema name and context.


Step3: provide Data server details like Name, User, password, driver, url etc. Next and test connection.


Step4: Provide Physical schema nane, db schema names.

Step5: Model will be created.



Step6: Go to Reverse Enginner and do mask for selecting tables if you need.

Step7: Go to selective Reverse engg a d select objects to reverse engg.

Step8: Datastores tables will be created. Just right click on any table and click view data



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Featured Post

OIC - Padding leading zeros to a number field using xslt format-number()

In many payment-related integrations, credit card numbers often arrive as plain numeric strings. For security and compliance—and to meet tar...