Hi,Can Informatica power center 7.1.1 installed on Windows vista home premium? If so how to install informatica server and repository server?Thank you,Vamshi.

anithashriya

 Profile Answers by anithashriya Questions by anithashriya

• Dec 22nd, 2007

But i could not find an option windows xp service pack 2 after right clicking on setup.exe of informatica powercenter 7.1.1, still the error is continuing if i try to execute setup.exe ...can anyone come up with the solution

Pallavi50953

 Profile Answers by Pallavi50953 Questions by Pallavi50953

• Dec 21st, 2007

Hi,   I installed informatica powercenter 7.1 in my laptop and i can even open repository server console.   But now for connecting to the repository it is asking for a password.Can any one specify which port and password should i specify for connecting to the repository.

Answer Question  Select Best Answer

Create a matrix query to display the job, the salary for that job based on department number and the total salary for that job, for departments 20,50,80, and 90,giving each column and appropriate heading.

sachin

• Apr 18th, 2012

Select job,
sum(decode(deptno,10,sal)) deptno10,
sum(decode(deptno,20,sal)) deptno20,
sum(decode(deptno,30,sal)) deptno30,
sum(decode(deptno,40,sal)) deptno40
from emp group by job order by 1;

Neha

• Sep 25th, 2011

Select job in job, sal in salary, sum(salary) in total_sal
where job=(select job in job where deptno=20 and 50 and 80 and 90)
;

Answer Question  Select Best Answer