Relation Database and Warehousing Treasure Trove

Comments

Post a Comment

Popular posts from this blog

Using DEFAULT clause for populating Surrogate Keys

In Oracle Database 12 c , a suite of improvements has been implemented around the DEFAULT clause for table columns. A sequence value can now be assigned as the default value for a column. With one simple command, we can remove the need for triggers for populating Surrogate Keys. Creating a DB Trigger: SQL> create or replace   2  trigger TRG_SALES_SURROGATE_KEY   3  before insert on SALES   4  for each row   5  begin   6    :new.SALE_SEQ := SEQ_SALES.nextval;   7  end;   8  /   Trigger created.   Inserting 10 million rows for testing the Insert time.   SQL> insert /*+ APPEND */ into SALES   2  select rownum, ...   3  from   4   ( select 1 from dual connect by level <= 10000 ),   5   ( select 1 from dual connect by level <= 1000 )   6  /   10000000 rows created.   Elapsed: 00:06:3...
Read more

XML Analyzer for Informatica PowerCenter

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