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.

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,

---

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

---

Why use the lookup transformation ?

2 Answers   Informatica,

---

how we can update a target table without update strategy and update override?

3 Answers   TCS,

---

How union transformation is active ?

2 Answers   Puma,

---

---

How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,

---

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers  

---

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,

---

How can you complete unrcoverable sessions?

1 Answers  

---

what is SDLC way of code development?

0 Answers  

---

What are the measure objects?

0 Answers  

---

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

---