Answer / srinu

unonnected lookup

Answer / ankit kansal

Unconnected Lookup is a better option as It will fire a sequel query whenever it was being called from other transformation using :LKP.lkp_trans(fieldname).

Or

Create a persistence cache for that table if it's not getting updated frequently. and use this cache in different other jobs.

http://deepinopensource.blogspot.in/

What are active transformations? Name them.

1 Answers  

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

---

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

---

How to call shell scripts from informatica?

0 Answers  

---

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

---

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  

---

how to insert header after each group.

1 Answers   IBM,

---

Explain the flow of data in Iinformatica?

1 Answers  

---

What is log file,and where is it located,why u r using the log file

1 Answers   TCS,

---

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

---

Difference between Target-based loading and constraint-based loading?

0 Answers  

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  

---