We can create scenarios under package, procedure and interface.
Here, we will create a scenario under a package.
UseCase: Create a map between a source and target db table and use them in a package and create a scenario and execute.
Steps:
Step1: Connect to your odi mastet and work repository
Step2: Project - new mapping - MAP_SCENARIO ok
From model drag and drop source and target tables in the logical schema section.
Do auto map by name.
- Region_id to region_id
- Name to name
Save
Step3: Go to Physical tab and select default and Loading knowledge module as "LKM SQL to SQL".
Select target table and IKM as "IKM SQL Contol append".
Flow control = False as we dont have any primary key.
Save run ok
Step4: Go to operator tab - check date - today
Step5: Package - new package - PKG_Scenario
Choose map_scenario into the package.
Run ok
Step6: Click on PKG_SCENARIO and generate scenario
Providr package name PKG_Scenario and version 001
Ok
It will show under scenarios and package
Step7: Right click on pkg_scenario version 001 and run
Check operator tab for execution status
Note: Suppose now we add some filter in the map and edit source table field "Region_id" as Default.REGIONS.region_id in (1,2) for region id
Save and run the scenario again but the change will not refelect .
Create another version 002 scenario and run . This time the change will reflect.
No comments:
Post a Comment