- If you want to make changes to the Oracle Business Analytics Warehouse, you must create a custom folder and make the changes in it.
- Do not change objects in any of the shipped folders unless explicitly directed by Oracle.
- The shipped folders and the objects within them might be overwritten in future upgrades.
- The deployed Informatica Repository does not include any custom folders; you must create your own.
- You should create a custom folder for each SDE folder you have deployed that will have customizations.
- These folders hold the extract mappings to various sources.
- You should also create a separate custom folder for customizations you want to make to the SILOS folder. Do not store customized extract and load mappings in the same folder.
- The easiest way to modify an object is to copy an existing object from the shipped folder into the corresponding custom folder and to reuse existing business components, source and target definitions, transformations, mapplets, and mappings.
Note:
- If source tables are extended, then the source tables require manual editing in Informatica PowerCenter Designer.
- Do not import the tables from the database into the repository, because it changes the source table definitions for the entire Oracle Business Analytics Warehouse.
- When importing new tables from the database into the custom folder, use the Oracle Business Analytics Warehouse and transactional database ODBC database connections (using the ODBC drivers supplied by your database vendor) to connect to the source and target databases.
- After importing new table definitions, change the database type to Oracle in the Informatica Repository, regardless of the database platform you are using.
- This has no effect on the choice of a relational database.
- This step is very important because in Informatica if the database type of the source tables are not identical, all mappings and workflows that refer to the source tables will be invalid.
No comments:
Post a Comment