Datawarehouse Architect

Step by step procedure to configure Outlook for webmail server to send e-mails from Informatica. Step1: Go to Outlook. (Pic shown below) Outlook -> File -> Account Settings Step2: In Account Settings, add Sender and Recipient E-mail accounts. Select "Sender Email Account", and click on "Set as Default" Step3: Double-click on the "Sender Account", give the details as shown. Step4: Click on "More Settings". In "Advanced" tab, give the details as show in the pic below. In "Outgoing Server" tab, give the details as show in the pic below. Step5: Add Outlook Data Files as shown below. Step6: Create a distribution list with all the recipient e-mail ids, in the outlook address book. Step7: Go to Informatica Administration Console. Click on "Domain" and go to Properties. Give the "SMTP Confi...

Before you go for OBIEE 11.1.1.7.0 installation you need create schema from RCU (Repository creation utility) Follow the same step as per the screen shot. Click on create and load component schema into a database Give hostname, port, service name and sys username password to create schema It will do pre-check and give on OK Select AS Common schemas and Oracle Business Intelligence Click Ok Give common password Click on OK Click on OK Click on OK Click on Ok Click on Create By this your Repository has been created. Start Installing OBIEE 11.1.1.7.0 now. Click on setup file of OBIEE 11.1.1.7.0 Give Next Check on Skip Software Updates Give Next Go with Enterprise Install Hit the password and give next Select some empty directory and give next Give Yes and hit on Enter Give next Give Database credentials and hit on enter Give Database credentials and hit on enter Select Auto Port configuration and hit enter Give next Click on Install Click on Next Hit on Finish you are done OBIEE 11.1....

Creating a mapping and executing it in new platform is conceptually the same as PowerCenter, though the user interface varies quite a bit. we look at all the steps required to create a mapping and successfully execute it in the new platform. Connections Connections can be created in PowerCenter Administrator web console that can be used in the Developer tool. Follow the steps given below to create a connection in the administrator:  a. Go to Administrator console  b. Go to Domains tab àConnections sub tab c. Right click the domain name  d. Select the connection database type (such as Oracle)  e. Provide username, password, connection string details and click Finish Physical data objects Just like in PowerCenter, to begin developing a mapping, we need to import the source and target definitions first. These are known as Physical Data Objects (PDOs). a. Connect to the Model Repository b. Open the project where ...