Tuesday, September 15, 2020

How to create variables in ODI

A variable is an object that stores a single value. This value can be a string, a number or a date. The value is stored in Oracle Data Integrator, and can be updated at run-time.

Creating Variables

Now we need to save this variable and you pass in any mappings

Then we need to take source and target in between that we need to give filter condition.

Later we have to edit filter condition by using gear option which is highlighted.

Here we need to select variable by double clicking in odi objects click on apply ang give ok.

Now we can see output as

Refreshing concept:

Firstly we need to create one table after that craeting column name as vardeptno which is variable name.

Now we need to refresh it and it shows run then click on ok.

Then come back to your mapping and again run your mapping.

 

Finnaly we get output as:

   

 

 

 

 

 

 

 

 

 

3 comments:


  1. Thanks for sharing this blog this content is very significant for me I really appreciate you.

    click here now


    ReplyDelete
  2. The tutorial is very helpful for a first timer like me, by the way if you could have given a
    tutorial on creating a free blog, it would have been very helpful for newbies like me.
    click here now



    ReplyDelete
  3. At APTRON NOIDA, we offer comprehensive Ab initio Training in Noida that covers everything from the basics to the advanced concepts of this powerful ETL tool. Our instructors are experts in their field, with extensive experience working with Ab initio in real-world scenarios. They can teach you how to design and develop complex ETL workflows, troubleshoot common issues, and optimize performance.

    ReplyDelete