Thursday, September 4, 2008

Focus Areas for Improved Performance on OBIEE ETL

OBIEE DAC Full load & Incremental load ETL duration Focus Areas for Improved Performance:
1: Change Capture Takes More Time in ETL Process in OBIEE DAC for Siebel Marketing
2: Composite Key for Fact Table ( all foreign keys of the Fact Table)
3: Drop and Create Indexes Manually After DB Migration
4: High Waterfall Mark issues to be addressed in the Database Objects
5: Database Volume on OLAP Database
6: Maximum Sessions parameter value in DAC to Determining the Informatica Server Maximum Sessions Parameter Setting
7: maximum number of work flows that can be executed in parallel on the Informatica server.
8: Drop Unsed Objects and compile the invalid objects in the Database
9: Disable Jobs / Tasks that re not part of the execution Plan of the Current ETL.
10: use union or union all in the SQL Qualifier instead of 'OR', Remove Duplicates from Staging Table.
11: Bulk Loading in Informatica.

Thanks
BSK

No comments: