Datawarehouse Architect

I find some guys facing so much of challenges in creating integration services. So I guess the below screenshots will be useful for them to create integration services in Informatica 9.5.1 Create Integrate Services - Informatica 9.5 Create Integrate Services - Informatica 9.5 Create Integrate Services - Informatica 9.5 Create Integrate Services - Informatica 9.5 Create Integrate Services - Informatica 9.5 start services Create Integrate Services - Informatica 9.5 Create Integrate Services - Informatica 9.5 Create Integrate Services - Informatica 9.5

Problem: I got wired issue today saying [NQSError:61013] File error, There has been a sharing violation  Solution:  This problem came to me when I was developing repository object and I left it open for 2-3 days. And again when I started back after 3 days it was not allowing me to save changes which I done.  Just open the RPD in online mode and make some changes in repository and save it. If you don't want to loose the change stop the server, save and then close the administrator, and start the server

I recently faced this error [nQSError: 35008] when am trying to check out  OBIEE Admin tool. Problem:   I was trying to create dynamic repository variable, and when I try to check out and save repository  OBIEE Administrator tool got freeze.  Solution: Start and Stop the BI service resolved my issue. I could not give much time to analysis this problem.  I will analysis and give the reason behind this problem very shortly. but for now I bounced the services and started working back. Cheers  Kashif M

Navigate to Programs > Oracle Business Intelligence > Administration. Launch Oracle BI Administration. Open the Oracle BI Repository 'OracleBIAnalyticsApps.rpd 'in offline mode. From the menu, select Manage > Variables In the tree structure in the left pane of the variable manager window, select Repository > Variables > Static In the right pane, double-click on OLAP_DSN to edit this variable. In the Default Initializer field, enter 'ORCL'. Click OK to return to the variable manager window In the right pane, double-click on OLAP_USER to edit this variable. In the Default Initializer field, enter 'BAW'. Click OK to return to the variable manager window In the right pane, double-click on OLAPTBO to edit this variable. In the Default Initializer field, enter 'BAW'. Click OK to return to the variable manager window In the right pane, double-click on OLTP_DSN to edit this variable. In the Default Initializer field, enter 'R12PLY...

Click on Execute. In the Execution Plan tab, select 'Custom_R12_Financials' which is the execution plan that just created for Financials Check the "Full Load Always" and "Drop/Create Indexes" box. Click Save Click the "Run Now" button Click Yes Click OK Click the "Current Run" tab to monitor the process Click Auto Refresh to choose the automatic refresh frequency Navigate to Run History tab, click on the "Run Status" to check the status. It should return with the status 'Completed'

In DAC, click on the Setup menu. In the DAC System Properties tab, locate the "TestRun" property. Change the value to "true". Click Save

Copy ParameterfileDW.txt and ParameterfileOLTP.txt files from OracleBI DAC Metadata directory to DAC101341 Informatica Parameters directory For example OracleBI DAC Metadata = C:\OracleBI\dwrep\DAC_metadata\DAC_Server DAC101341 Informatica Parameters = D:\oracle\DAC101341\bifoundation\dac\Informatica\parameters\input