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

What is a filter transformation?

0 Answers  

---

What is domain and gateway node?

0 Answers  

---

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,

---

What is Index Caches size?

0 Answers   Informatica,

---

In ur current projectu have done any performance tuning of mappings?

1 Answers  

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,

---

why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,

---

How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,

---

Enlist few areas or real-time situations where informatica is required.

0 Answers  

---

What is a difference between complete, stop and abort?

0 Answers  

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---