Skip to main content

Posts

Informatica Repository Configuration for OBIA 7.9.6.3

Repository services ::: (database property , newly created user at database)  Username : sh Password : sh Integration services :::: username : Administrator Password : Administrator This password because while creating database configuration we have assigned this integration service to the domain and so domain username and password comes here as Administrator Check whether both integration service and repository services are up or not , if not then go to repository service Γ  change the mode to Γ  normal mode from exclusive mode Changing from one mode to another mode, services stops or disabled or not able to up the services again, in those cases it is advisable to uninstall the complete application and re-install it (restart the machine in between). Unistall Process NOTE During the installation process of informatica, if you face any issues, it is advisable to uninstall and re-install the whole informatica (Server and client). Below are the steps 1) Stop Informatica S...

Drivers for DAC Database Connectivity

Search for the ojdbc14.jar file from your oracle installed folder Drivers for DAC Database Connectivity Copy the file ojdbc14.jar and paste it in DAC lib folder path - F:\orahome\10gR3_1\bifoundation\dac\lib Drivers for DAC Database Connectivity

Installing DAC Metadata Files

DAC metadata files are installed by the Oracle BI Applications. You need to copy these files to the machines hosting the DAC Client and Server. DAC Metadata Files That Need to Be Copied to DAC Client Machine and DAC Server Machine Export directory  F:\MiddlewareHome\Oracle_BI1\biapps\dwrep\dac_metadata\dac_client\export  F:\orahome\10gR3_1\bifoundation\dac\export  DeleteTriggers.list  F:\MiddlewareHome\Oracle_BI1\biapps\dwrep\dac_metadata\dac_client  F:\orahome\10gR3_1\bifoundation\dac\conf  parameterfileOLTP.txt  F:\MiddlewareHome\Oracle_BI1\biapps\dwrep\dac_metadata\dac_server  F:\orahome\10gR3_1\bifoundation\dac\Informatica\parameters\input  parameterfileDW.txt F:\MiddlewareHome\Oracle_BI1\biapps\dwrep\dac_metadata\dac_server  F:\orahome\10gR3_1\bifoundation\dac\Informatica\parameters\input  ...