QUESTIONS

DESIGNER

Target and Source Metadata.
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

What is LKM & IKM ?