Answer / elango

It depends on the complexity of resuablity or re-mapping
based on the client specification.

So this question is to check whether r u smarter enough to
understand the existing mapping and design new ones.

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

---

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  

---

What is the difference b/w natural key and surrogate key

1 Answers  

---

What are the tasks that source qualifier performs?

1 Answers  

---

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

1 Answers   Wipro,

---

Define maping and sessions?

3 Answers  

---

difference between stop and abort

2 Answers  

---

How do we call shell scripts from informatica?

0 Answers  

---

Define error Threshold?

1 Answers  

---

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

1 Answers   IBM,

---

disable caching in a lookup transformation?

1 Answers  

---