Answer Posted / 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/

Under what condition selecting sorted input in aggregator may fail the session?

1060

---

Differentiate between joiner and lookup transformation?

1049

---

Did u used latest transformations of 8.6.0? for what?

1826

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2681

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2296

---

While migrating the data from one environment to another environment how would you manage the connections?

1048

---

What is an Integration service in Informatica?

1085

---

What is joiner change?

1079

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1631

---

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

998

---

Explain what are the different versions of informatica?

1037

---

How can we improve session performance in aggregator transformation?

1042

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2228

---

How can we use mapping variables in informatica? Where do we use them?

1101

---

What is persistent lookup cache?

970

---