Answer / hari

Connected lookup
1.input ports are connected through pipeline
2.we can have more inputs and more outputs
3connected lookup we can use both static and dynamic cache
4.if condition not match default it give values

Unconnected lookup
1. Inputs are connected through calling :LKP from expression
2.inputs are more and output returns one
3.only static cache can use
4.if condition not match it gives nulls

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

---

Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com

0 Answers  

---

what is the difference between stop and abort?

3 Answers   TCS,

---

What are the rank caches?

2 Answers   Informatica,

---

What is confirmed dimension with scenario

1 Answers   HCL,

---

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,

---

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,

---

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

---

why we use stored procedure transformation?

4 Answers   IBM,

---

State the limitations where we cannot use joiner in the mapping pipeline?

0 Answers  

---

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

---

How to recover the standalone session?

2 Answers  

---