Datawarehouse Architect

umask 022; export LD_ASSUME_KERNEL=2.4.19; export ORACLE_SID=devbi; export ORACLE_BASE=/u01/app/oracle; export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/u01/oracle/bin:$JAVA_HOME export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib:/lib64:/usr/lib64:/usr/local/lib64:/usr/X11R6/lib64 # Added for OBIA environment export TNS_ADMIN=$ORACLE_HOME/network/admin # export NLS_LANG=American_America.UTF8 # export LANG=en_US.UTF-8 # export LC_ALL=en_US export PM_HOME=$ORACLE_BASE/product/Informatica/PowerCenter8.1.1 export INFA=$ORACLE_BASE/product/Informatica/PowerCenter8.1.1 export INFA_HOME=$ORACLE_BASE/product/Informatica/PowerCenter8.1.1 export OracleBI_HOME=$ORACLE_BASE/product/OBIEE_10.1.3.4/OracleBI export OracleBIData_HOME=$ORACLE_BASE/product/OBIEE_10.1.3.4/OracleBIData export PATH=$PATH:$ORACLE_HOME/jdbc/lib:$OracleBI_HOME/server/bin:$OracleBI_HOME/setup:$...

Download Softwares • Download Java JDK for Sun and Windows operating system • Download Hibernate Libraries • Download OBIEE and BI Applications Software Create Databases Before you install Oracle Business Intelligence Applications and Informatica PowerCenter, create database tablespaces for: • BAWDEV (Data Warehouse tables) • DACDEV (DAC Metadata tables) • INFADEV (Informatica Repository Metadata tables) • INFADMDEV (Informatica Domain tables) Create a database role named SSE_ROLE and granted insert, update, delete, select and basic DBA privileges. CREATE ROLE "SSE_ROLE" NOT IDENTIFIED; GRANT CREATE CLUSTER TO "SSE_ROLE" GRANT CREATE DATABASE LINK TO "SSE_ROLE" GRANT CREATE DIMENSION TO "SSE_ROLE" GRANT CREATE MATERIALIZED VIEW TO "SSE_ROLE" GRANT CREATE PROCEDURE TO "SSE_ROLE" GRANT CREATE ROLE TO "SSE_ROLE" GRANT CREATE SEQUENCE TO "SSE_ROLE" G...

Create ODBC Database Connections Install and configure on the Developer Machine that will host the DAC Client and Informatica PowerCenter Tools The machines that will host these components require connectivity to the Oracle Business Analytics Warehouse (target) database, transactional (source) database(s), and the DAC and Informatica repository databases. Start up ODBC Data Source Administrator. In the System DSN table, click Add You must use the Oracle Merant ODBC driver to create the ODBC connections. The Oracle Merant ODBC driver is installed by the Oracle Business Intelligence Applications installer. Therefore, you will need to create the ODBC connections after you have run the Oracle Business Intelligence Applications installer and have installed the DAC Client Select the ODBC driver “Oracle Merant ODBC Driver”. Click Finish Enter the information in the Oracle ODBC Driver Configuration Dialog Box; for exa...