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 the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1250

---

Explain constraint based loading in informatica

1152

---

I have a flat file, want to reverse the contents of the flat file

1171

---

What is an Integration service in Informatica?

1190

---

Differences between version 7.x and 8.x.

1939

---

What is pmcmd command?

1178

---

Briefly explain the aggregator transformation?

1065

---

What is a router transformation?

1212

---

lookup transformation with screenshots

4048

---

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

1264

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2184

---

How can you validate all mappings in the repository simultaneously?

1422

---

What is deployment group?

1296

---

What are the main issues while working with flat files as source and as targets ?

1216

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1062

---