Answer / venkat

decode is better perform than iff condtion,decode can be
uesd insted of using multiple iff cases

Answer / abhishek guddu

DECODE FUNCTION YOU CAN FIND IN SQL BUT IIF FUNCTION IS NOT
IN SQL. DECODE FUNCTION WILL GIVE CLEAR READABILITY TO
UNDERSTAND THE LOGIC TO OTHER.

Answer / james

Decode function has better performance than IIF function,
bcoz for multiple conditions we have to use nested queries
when u r going with IIF whereas with Decode u don't have to
write nested queries.

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,

---

Write the program through which the records can be updated?

0 Answers  

---

What is informatica etl tool?

0 Answers  

---

What is the fact table?

0 Answers  

---

what is runtime variable?

3 Answers   TCS,

---

How can you validate all mappings in the repository simultaneously?

0 Answers  

---

how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

---

What do think which one is the better joiner or look up?

0 Answers  

---

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

---

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

0 Answers   Informatica,

---

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,

---

How can a transformation be made reusable?

0 Answers   Informatica,

---