How does the Dimensions get their ROW_WID(s), which are the dimensions PKs? Well it is not done by the database systems. Instead, the PKs are controlled by Informatica using Sequence transformations. These Sequence transformations are within the mplt_SIL_XXX(s) within the SIL mappings. Remember in my prior post on mapplets defined in OBIA, these *_SIL_* mapplets [...]
Archive for May, 2011
Sequence Generators in Informatica and BI Apps
Posted in Oracle BI Apps on May 23, 2011 | Leave a Comment »
OBIA Mapplets defined
Posted in Oracle BI Apps on May 18, 2011 | Leave a Comment »
There are pretty much 4 predominant types of mapplets in OBIA Infa ETL. Business Component (ex: mplt_BC_XXX) – These mapplets are used to extract the data from the source systems. They are only found in the SDE folders and start off the majority of the mappings. Within these mapplets, you will find the Source Tables [...]
DAC Error Message : The specified task name, workflow name, or folder name does not exist. @DAC_XXX
Posted in Uncategorized on May 12, 2011 | 4 Comments »
Just came across this one today. This appears to be only in v7.9.6.2 as I have not seen before. Here is the snippet of error message from DAC: 2011-05-12 08:43:50.358 INFORMATICA TASK:SILOS:@DAC_SIL_PositionDimension_FULL_TD_CMD:(Source : FULL Target : FULL) has started. ANOMALY INFO::: Error while executing : INFORMATICA TASK:SILOS:@DAC_SIL_PositionDimension_FULL_TD_CMD:(Source : FULL Target : FULL) MESSAGE::: Irrecoverable Error [...]
