When you develop a considerable amount of interfaces, involving a considerable number of tables, columns and transformations, the last thing you want to do is re-open them to describe their behaviour.
Luckily, ODI provides a feature for generating PFD documents of your job. To use this functionality, you first have to configure it.
In ODI->User Parameters, you have to edit the following entries:
- Default PDF generation directory: this is the complete path to the folder you want to save your documentation to. E.g. C:\TEMP\
- PDF Viewer: Full path to your PDF viewer. E.g. C:\Program Files (x86)\Adobe\Reader 10.0\Reader\AcroRd32.exe
ODI allows you to generate documentation for the following objects:
- Knowledge Modules: right click on a project, then Print -> Print Knowledge Modules
- Packages: right click on a project folder, then Print-> Print Packages
- Procedures: right click on a project folder, then Print -> Procedure
- Interfaces: right click on a project folder, then Print -> Interfaces
- Folders: right click on a project folder, then Print ->Folder
The thing I like the most is the fact that for every interface you get the physical structure of every source and target table, every join and, most important, each transformation you apply to get a target column.