Answer Posted / dharmendra singh

Suppose your look table has f_name,m_name,l_name and you
are using unconnected lookup.In override SQL of lookup use
f_name||~||m_name||~||l_name you cna easily get this value
using unconnected lookup in expression.use substring
function in expression transformation to separate these
three columns and make then individual port for downstream
transformation /Target.

What is blocking transformation?

1123

---

What is a router transformation?

1099

---

Sequence generator, when you move from develoment to production how will you reset

2009

---

What are the guidelines to be followed while using union transformation?

1116

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8205

---

Clarify the utilization of aggregator cache record?

983

---

What is data transformation manager process?

1130

---

what is song in infrmatica...?

2213

---

What are mapplets? How is it different from a Reusable Transformation?

1069

---

What is the reusable transformation?

1031

---

In informatica workflow manager, how many repositories can be created?

1329

---

Which are the different editions of informatica powercenter that are available?

1018

---

where to store informatica rejected data?

1077

---

how tokens will generate?

2186

---

What are the types of schemas we have in data warehouse and what are the difference between them?

923

---