Insights and Tips from the Experts



Modernization, Cloud Enablement, Managed Services

Quick Tip: Use ODICS Simulations to test your Mappings code before deployment.

[fa icon="calendar"] July 7, 2018 / by Aakash Rami, Highstreet

Easily execute data transformations where the data lies, without having to copy data unnecessarily to remote locations during data processing.

Oracle Data Integrator Cloud Service (ODICS) provides push-down data processing; high performance E-LT with less data movement which is best for the Cloud.

E-LT-Architecture

In Oracle Data Integration Cloud Service, once you have created your Mappings, a great way to test the code is to run a Simulation.

When you Execute a Mapping, there is a checkbox for Simulation. When you check the Simulation box, the Mapping does not execute, but all of the code for the Mapping is generated. This includes code for all LKM, IKM, CKM, Options, etc. for the Mapping.

ODI_Simulation

  • If you sift through the code you will find the SQL that is passed to the database.
  • You can use this code, replacing inserts with selects and run this SQL in the source database.
  • You will see the results before you Execute the Mapping and hence unit test your Mapping.

You can also use this Simulation to troubleshoot different KMs and see exactly what SQL is being generated and which KM is the right KM for your Mapping.

Or if you can’t figure out an error in your Mapping, run the Simulation and search the code. It’s exactly what is being passed to the database!

 

Topics: Quick Tip, Oracle Cloud

Subscribe

Highstreet provides modernization, cloud enablement, and management services for your applications and IT infrastructure. Learn more.

Browse Posts

New Call-to-action
Four Essential Strategies to Optimize your PeopleSoft Environment
Enhancing the Modern User Experience with PeopleSoft Fluid
New Call-to-action