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

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

---

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 Answers  

---

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

---

in which situations do u go for scds ?

3 Answers   TCS,

---

Describe data concatenation?

0 Answers  

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?

3 Answers   CTS, Wipro,

---

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,

---

Difference Between ETL & ELT?

1 Answers   TCS,

---

why we use informatica in our project?

2 Answers   TCS,

---

How to create the source and target database connections in server manager?

0 Answers   Informatica,

---

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  

---