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.

Mention few power centre client applications with their basic purpose?

951

---

Enlist the various types of transformations.

1052

---

How to partition the Session?

1110

---

How would you copy the content of one repository to another repository?

1016

---

Explain the different dimensions.

963

---

What is the Process to creating lookup transformation in informatica

1042

---

How to load the data from people soft hrm to people soft erm using informatica?

1010

---

What does reusable transformation mean?

1132

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1052

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1199

---

How to open an older version of an object in the workspace?

1203

---

can u give example for factless fact table

6643

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2251

---

What is data caches/ index caches?

1100

---

What is resilience time?

1134

---