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 23rd, 2011
Sequence Generators in Informatica and BI Apps
Posted in Oracle BI Apps on May 23, 2011 | Leave a Comment »
