ODI - A Journey - DAY 2
Published: 2024-03-25 22:10:30

## 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.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/bdhb0td82miv382b22a4.png)

- Now create new model ,

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/lz43i8dkhi9ykrk4pz3d.png)

- 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.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/n9rf0pneynoz00iy2rcn.png)

> **Reverse Engineering**

- Types of object to reverse engineering.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/yfbpucdzpr8isj6op0i9.png)

> **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.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/w8g1dy0e0204ofzunntr.png)

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

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ur2g40zisa1f2vvi23i5.png)

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/tm595pzjbyb3izpzb96m.png)

- 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.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/addyflo28pkuvr09ijfb.png)

> **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.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ymhioqipot2nl9509oal.png)

- 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 ?

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/nnssfm7wfk6m67880vlx.png)

> **MAPPING**

- Map the Source to Target in the Logical panel.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/xyysgkd61chab7cjxi8m.png)

- 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 ?

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/szcp2n9ygzqs84e5q01o.png)

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/duzmscot4x5f60xzdp4q.png)

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

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/j1hlvk8olhum3fslth3t.png)

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

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/mdanq3zqm635x9vrk18a.png)

- Validate the mapping.
- RUN the Project.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/w9v8hk3moo9ejv7dhqke.png)

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

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ivqxkm63z9bwjwustm4o.png)

- Once the execution completed , go to Operation Tab.

## OPERATION

- You can view the execution.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/53bkgcr84z9pt45ghb71.png)

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

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4smcvtnbudefplkzlwke.png)

# QUESTIONS

1. What is LKM & IKM ?