Data Converse

     I truly believe Informatica is most refined ETL tool in the martket today, but ODI is giving a tough competition with newly added features in 12c, aggressive marketing of ORACLE offering ODI as an embed product within their products.

This is a tool that should help to quickly fetch some useful information from Mapping or Workflow XML file and display them in a business-user friendly format. Features: * Ability to download each source-to-target mapping dependency analysis as tab delimited file  (NEW!) * Full Mapplet support  * Reporting transformation ports with default names  * Transformation-level naming convention  * Reporting any implicit datatype conversions  * Reporting Precision / Scale mismatches between linked ports  * List Workflow variables  * List Mapping variables  * Checking for variables unused in mapping  * Added source and target data type to source-to-target column mappings  * Reporting Session level SQL overrides with corresponding Mapping level SQLs  * Listing all source-to-target column mappings * Comparing workflow log file with workflow name * Checking if a session is valid * Checking if a mapping is valid * Tracing level * Overridden ...

While using Informatica, may be during installation or coding or data loads we may observed errors n either in logs or in prompt messages.  Similar to ORACLE error codes, Informatica also provides its own set of error messages description out of its identified scope in a documentation. You may download this from below link.  Hope this will be helpful during your work with this tool.  https://community.informatica.com/servlet/JiveServlet/download/116398-40025/IN_951HF2_MessageReference_en.pdf

http://www.kimballgroup.com/

 Source: Public post. Click here to download.

source:  Click here for source page.