Answer / praveen

$PMBWPARAM

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,

---

Define Pmrep command?

0 Answers  

---

What are the rank caches?

2 Answers   Informatica,

---

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

---

---

How can we use batches?

0 Answers  

---

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?

1 Answers   IBM,

---

What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers  

---

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers   Cognizant,

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers   HP,

---

if i am having 10 records in source, i want 20 records in target...how will you do it

13 Answers   BirlaSoft, IBM,

---

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

---