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

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

---

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

---

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,

---

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,

---

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,

---

what is incremental aggregation ,with example?

2 Answers  

---

Enlist the tasks for which source qualifier transformation is used.

0 Answers  

---

Is it possible to use a client with different version than that of its Informatica server?

0 Answers  

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,

---

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

2 Answers   Emphasis,

---

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

---

How can a transformation be made reusable?

0 Answers   Informatica,

---