disable caching in a lookup transformation?
How do you take care of security using a repository manager
What is a parameter When and where do you them when does the value will be created
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
select count(1) from emp? what is the o/p?
How can we use mapping variables in informatica? Where do we use them?
Where do we use mapping variables in informatica?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
What are the measure objects?
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
design of staging area?
what are the differences between powercenter 8.1 and powercenter 8.5?
What is the difference between informatica 8.x and 9.x