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

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

---

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

---

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

---

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

---

What are the uses of a Parameter file?

3 Answers   CSC,

---

---

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

---

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  

---

To achieve the session partition what r the necessary tasks u have to do?

1 Answers  

---

why we r using presql&postsql in source qualifier?

1 Answers   HP,

---

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers  

---