Clover Infotech ODI Developer Interview Questions, Process, and Tips

A procedure in ODI is a set of instructions or actions that are executed in a specific order to perform a specific task.

• A procedure in ODI is created using the ODI Studio interface.

• It can be used to perform various tasks such as data integration, data transformation, and data loading.

• Procedures can be scheduled to run at specific times or triggered by events.

• They can include multiple steps or actions, such as extractin...read more

Mapping in ODI is the process of defining the relationship between source and target data structures.

• Mapping involves specifying the transformation rules to be applied to the source data.

• It determines how the data will be extracted, transformed, and loaded into the target structure.

• Mappings can be created using ODI's graphical interface or by writing code in ODI's declarative language.

• Mappings can include various trans...read more

A package in ODI is a container that holds related objects and components for organizing and managing data integration processes.

• Packages are used to group together related objects such as interfaces, procedures, variables, and more.

• They provide a way to organize and manage data integration processes in ODI.

• Packages can be used to define the execution order of objects within a process flow.

• They can be scheduled for aut...read more

SCD stands for Slowly Changing Dimensions. It is a technique used in ODI to handle changes in data over time.

• SCD is used to track and manage changes in dimension tables

• It helps in maintaining historical data and tracking changes in attributes

• There are different types of SCDs, such as Type 1, Type 2, and Type 3

• Type 1 SCD overwrites the existing data with the new data

• Type 2 SCD creates a new record for each change and ma...read more