This is something like finding a cheat code while playing video games.
The problem was that I wanted to check a source table for constraints (static control check if you may).
Normally it is done using the 'Check' option on the data-store, but what if I want to automate it in a package and don't want to go right-clicking the datastores everytime ?
To know what static control is, search ODIExperts blog or John Goodwin's blog. No point in re-inventing the wheel :)
To know what static control is, search ODIExperts blog or John Goodwin's blog. No point in re-inventing the wheel :)
I just thought of dragging the table (data store) onto the package area and voila !!, got the option to perform the check
Following are the constraints that I wanted to check in a package
Following are the constraints that I wanted to check in a package
Then I dragged the table directly onto the Package diagram
If you see the properties pane, you will be able to select the 'Datastore check' which will basically execute the constraints check on the table
No comments:
Post a Comment