Datawarehouse Architect

Before you run the Informatica PowerCenter installer, you must set environment variables on the Application Server.  You must set environment variables for database client, Library Path and Locale as below: export NLS_LANG=American_America.UTF8 export LANG=en_US.UTF-8 export LC_ALL=en_US PM_HOME=/obiee/obiee/Informatica/PowerCenter8.1.1 export PM_HOME INFA=/obiee/obiee/Informatica/PowerCenter8.1.1 export INFA export INFA_HOME=/obiee/obiee/Informatica/PowerCenter8.1.1 export ORACLE_HOME=/obiee/bidevdata/product/tahoedb/10.2.0 export ORACLE_SID=BIMAUI export PATH=$ORACLE_HOME/bin:/usr/openwin/bin:/opt/sfw/bin:/usr/local/bin:/ora_patch/OBIEE/JAVA/jdk1.5.0_12/jre/bin:/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/ucb:/obiee/obiee/10gAS/opmn/bin:$ORACLE_HOME/jdbc/lib:/obiee/obiee/OBIEE_10.1.3.4/OracleBI/server/Bin:/obiee/obiee/OBIEE_10.1.3.4/OracleBI/setup:$INFA:$INFA/server/bin:/obiee/obiee/OBIEE_10.1.3.4/OracleBI/DAC OracleBI_HOME=/obiee/obiee/OBI...

Browse to the installation directory, click “jdk-6-windows-i586.exe” For example: H:\OBIEE_Software_Unzip_10.1.3.4\java Click Run to run the software The Setup program will prepare the Installation Wizard for program setup process Click Accept to accept the License Agreement Change the Folder Name to C:\java\jdk1.6.0_06. Click OK Click Next to continue the installation Wait while the Install Wizard installs Java JDK1.6.0_06 Click Cancel when it prompts for installing Java JRE.  Click OK Once successfully installed, click Finish to exit

Browse to the directory where Oracle Business Intelligence software is located For example: H:\OBIEE_Software_Unzip_10.1.3.4\OBIEE_10.1.3.4_Windows\Server\Oracle_Business_Intelligence Click setup.exe to start the installation The InstallShield Wizard screen will appear to guide you through the process Check the requirements.  Click Next to continue if requirements are met Change the Installation Location to the desired drive. For example: Installation Location = C:\OracleBI Data Location = C:\OracleBIData Check the button next to “Basic: minimum security. Install Oracle Containers for J2EE (OC4j) “.  Click Next Check the “Complete” button for installing all the Oracle Business Intelligence components.  Click Next Enter the JDK location where Java JDK is installed. For example: C:\java\jdk1.6.0_06 Enter Administrator password “oc4jadmin”. Click Next Enter ...

This section explains how to install the Oracle Business Intelligence Applications files using the Oracle Business Intelligence Applications Installation Wizard. Browse to the Oracle BI Apps 7.9.5 installation directory    For example: H:\OBIEE_Software_Unzip_10.1.3.4\BI_Apps_7.9.5 Click setup.exe to start the installation The InstallShield Wizard will appear to guide you through the process Click Next to continue Enter the installation and data location of the installed Oracle BI 10.3.4. Enter the Java JDK installation location.  Click Next . For example: Oracle BI 10.1.3.4 installation location = C:\OracleBI Oracle BI 10.1.3.4 data location = C:\OracleBIData Java JDK installation location = C:\java\jdk1.6.0_06 Keep the check boxes for all the Financials Analytics applications. ·          General Ledger & Profitability A...

If you stop a session or if an error causes a session to stop, refer to the session and error logs to determine the cause of failure. Correct the errors, and then complete the session. The method you use to complete the session depends on the properties of the mapping, session, and Informatica Server configuration. Use one of the following methods to complete the session: Run the session again if the Informatica Server has not issued a commit. Truncate the target tables and run the session again if the session is not recoverable. Consider performing recovery if the Informatica Server has issued at least one commit. When the Informatica Server starts a recovery session, it reads the OPB_SRVR_RECOVERY table and notes the row ID of the last row committed to the target database. The Informatica Server then reads all sources again and starts processing from the next row ID. For example, if the Informatica Server commits 10,000 rows before the session fails, w...

During a session, the Informatica Server creates a reject file for each target instance in the mapping. If the writer or the target rejects data, the Informatica Server writes the rejected row into the reject file. By default, the Informatica Server creates reject files in the $PMBadFileDir server variable directory. The reject file and session log contain information that helps you determine the cause of the reject. You can correct reject files and load them to relational targets using the Informatica reject loader utility. The reject loader also creates another reject file for the data that the writer or target reject during the reject loading.  Complete the following tasks to load reject data into the target: Locate the reject file. Correct bad data. Run the reject loader utility NOTE: You cannot load rejected data into a flat file target After you locate a reject file, you can read it using a text editor that supports the reject file code page. ...