Search This Blog

Data Converse

It is a truth very certain that when it is not in our power to determine. What is true we ought to follow what is most probable. —Descartes - “Discourse on Method” ----------- I am a master student and always curious to work with data to drive some meaningful insights. I use this platform to share my 2 cents of knowledge and recent works in brief blog posts. I would love to get connected with data enthusiasts, please add my contact on LIn (https://goo.gl/mGdB4y) or email me at rchin001@odu.edu.

Relation Database and Warehousing Treasure Trove

Get link
Facebook
X
Pinterest
Email
Other Apps

June 29, 2015

http://www.kimballgroup.com/

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Informatica Message Reference guide.

October 05, 2015

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

XML Analyzer for Informatica PowerCenter

October 07, 2015

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 ...