What is ODI variable?

What is an ODI Variable? A variable is an object that stores a single value. This value can be a string, a number or a date. The variable value is stored in Oracle Data Integrator. It can be used in several places in your projects, and its value can be updated at run-time.

What is ODI package?

Now the ODI Package is the largest unit of execution in Oracle Data Integrator. A Package is made up of a sequence of steps organized into an execution diagram[1]. Each step can either succeed or fail its execution. Depending on the execution result (success or failure), a step can branch to another step.

How do you evaluate a variable in ODI 12c?

Create a Variable

1. Right click on Variables Node in Project or on Global Variables node in Global Objects tab in Designer navigator and click on Insert Variable.
2. Provide the Name, Action, Datatype and default value for the variable.

How do you evaluate a variable in ODI?

To insert an Evaluate Variable step:

1. Open the Package editor and go to the Diagram tab.
2. In Designer Navigator, select the variable to add to the Package from the Projects tree for a project variable or from the Others tree for a global variable.
3. Drag and drop the variable into the diagram.

What is ODI 12c procedure?

12.1. A Procedure is a set of commands that can be executed by an agent. These commands concern all technologies accessible by Oracle Data Integrator (OS, JDBC, JMS commands, etc). These options parameterize whether or not a command line should be executed as well as the code of the commands.

How can I call procedure in ODI 12c?

To create and run a procedure, perform the following steps:

1. 2.1 Configuring the Definition. On the left, on the Designer tab, expand.
2. 2.2 Task Drop Table. On the Tasks tab, click Add.
3. 2.3 Task Create Table. On the Tasks tab, click Add.
4. 2.4 Task Populate Table.
5. 2.5 Running Procedures.

What is ODI procedure?

A procedure in Oracle Data Integrator (ODI) consists of a series of commands executed in sequence. You use procedures in a package or a scenario, or you can run them directly from the Designer Navigator.

What is ODI architecture?

Oracle Data Integrator, or ODI, provides a new declarative design approach to defining data transformation and integration processes based on a unique Extract-Load-Transform (ELT) architecture. The declarative design approach separates the declarative rules from the implementation details.

How many ways can a procedure receive variables?

In PL/SQL, we can pass parameters to procedures and functions in three ways. 1) IN type parameter: These types of parameters are used to send values to stored procedures. 2) OUT type parameter: These types of parameters are used to get values from stored procedures.

How loop is implemented in ODI?

In ODI 11g we can implement this as follows.

1. Create a variable.
2. Create a package.
3. Set variable.
4. Evaluate variable.
5. Place your statements.
6. Increment your variable.
7. Connect the “Increment your variable” step to the “Evaluate variable” step.

What is Oracle ODI used for?

A widely used data integration software product, Oracle Data Integrator provides a new declarative design approach to defining data transformation and integration processes, resulting in faster and simpler development and maintenance.

What is the full form of ODI?

A One Day International (ODI) is a form of limited overs cricket, played between two teams with international status, in which each team faces a fixed number of overs, currently 50, with the game lasting up to 9 hours.

How do you create a variable in ODI?

The first variable will be used to store the date and time at which we started the process – only for the duration of the process. The second variable will be used to save that date for the next iteration of the package. To create a variable in ODI, expand your project and right-click on the ‘Variables’ folder. Then select ‘Insert Variable’ 1.1.2.

How to find the name of an ODI user?

It is possible to Retrieve the name of cuurent ODI user using ODI variable. There are two ways to display variable values in operator log. This technique would allow the recording of variable values during the runtie and would be useful for execution of audit operations.

How are ODI variables used in refresh mode?

The value inserted into the table may then be accessed in a package step made up of an ODI variable set up in the Refresh mode. Odi variables can not be used in substitution methods such as getObjectName. This is because due to the way the ODI source code parser works.

Which is the default data type in ODI?

Set the data type to ‘Alphanumeric’. The default value will be the original start date (basically the date for the oldest recors in our source file. (be careful here with the date format). No need to put a refresh value here. (Though an alternative may have been to put here a query to retrieve the oldest date in the source system!)