Answer / 9019

Sorter select distinct, aggregator group by columns

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---

Briefly describe lookup transformation?

0 Answers  

---

What is the scenario which compels informatica server to reject files?

0 Answers  

---

Explain pmcmd command usage in informatica

0 Answers   Informatica,

---

How many ways are there to create ports?

0 Answers   Informatica,

---

Explain the aggregator transformation?

0 Answers  

---

any body can say about all versions of informatica ?how many versions ?

2 Answers  

---

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  

---

What is the capacity of power cube?

1 Answers  

---

How an expression transformation differs from aggregator transformation?

0 Answers  

---

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,

---