Answer / amedela chandra sekhar

When we want to get single return port and also we can call
this any where in the mapping.

Answer / davan

if we take one look t/r, look up multiple times in one
mapping at that time we can go for un connected t/r

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  

---

What is synonym?

2 Answers   Patni,

---

what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,

---

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

---

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers   DELL,

---

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,

---

what are cost based and rule based approaches and what is the difference?

1 Answers  

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,

---

what is index?how it can work in informatica

0 Answers  

---

who is the best faculty for informatica in hyderabad ameerpet?

1 Answers  

---