ODI - A Journey - DAY 2

DESIGNER

1. Target and Source Metadata.
2. Here import from DB

MODELS

• New Model Folder
• Give any name , like Oracle i.e whatever the name you want.
• After giving the name you wont see anything while you expand.

• Now create new model ,

• Metadata taken from ORACLE DB here scott schema.
• Map the Logical schema name here.
• Write the description so that you will understand in future, why this Designer is created.

Reverse Engineering

• Types of object to reverse engineering.

Selective Reverse Engineering

• Difference between New Datastores & Existing Datastores. ( if you want to reimport the table again which the reverse engineering is done , that time you can enable the EXISTING DATASTORE )
• Click the Reverse Engineering here.

• See the difference carefully for " New Datastores & Existing Datastores "

• It will overwrite the existing one , but here is the super question . If my table as 5 columns at first --> reverse engineering is done --> There is some update in the table where the column is reduced to 4 --> if I click the reverse engineering what will happen ? ANSWER is --> It will replace completely . Can I create multiple copies here ?

• Create the Model for the target too like below.

PROJECTS

• New Projects --> Give any name.
• Once created , you will see

First Folder - Variables - Sequences - User Functions - Knowledge Module - Markers

• You can even create NEW FOLDERS also.
• Goto the MAPPINGS --> New Mappings --> Mapping Name.
• What is CREATE EMPTY DATASET ? It will create a EMPTY PANEL to drag and drop the source and target.
• Drag and drop the TARGET & SOURCE from the MODEL.

KNOWLEDGE MODULES

• Once the Target and Source are drag and dropped , now go to the KM.

• Select the KM.
• Here , Oracle to Oracle won't be there , so select SQL TO SQL as Oracle supports SQL.
• What is LKM & RKM , IKM ?

MAPPING

• Map the Source to Target in the Logical panel.

• Now goto PHYSICAL,source and target will be visible.
• Once you click the Default in the Target , select the LKM.
• LKM will create a TEMP table.
• FALSE means it will keep the TEMP date. Tell me will it consume more space in the target ?

• Keep an EYE ON THE INDEXES , if you need enable it.

• If the TARGET doesn't have the table , then enable this below options.

• Validate the mapping.
• RUN the Project.

• What is SIMULATION here ?
• Below option should be disabled , ( this is an option in the Oracle DB )

• Once the execution completed , go to Operation Tab.

OPERATION

• You can view the execution.

• Constrains --> Unique / Foreign keys.
• You can create NEW TASK also here , in future if you want to add.

QUESTIONS

1. What is LKM & IKM ?