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 are the types of data warehouses?

1528

---

How to start a workflow using pmcmd command?

1257

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2064

---

Have you worked with/created Parameter file

1668

---

What is the fact table?

1076

---

Partition, what happens if the specified key range is shorter and longer

2503

---

Explain the pipeline partition with real time example?

1145

---

Explain sql transformation in script mode examples in informatica

1142

---

How do you update the records with or without using update strategy?

1121

---

Explain dynamic target flat file name generation in informatica

1063

---

What is standalone command task?

1319

---

How to configure mapping in informatica?

1177

---

What is workflow manager?

1055

---

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

1208

---

What is informatica metadata and where is it stored?

994

---