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.

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

---

can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers   Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,

---

What are pre and post-session shell commands?

0 Answers  

---

Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?

4 Answers  

---

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,

---

What are the rank caches?

2 Answers   Informatica,

---

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  

---

Explain target update override in informatica

0 Answers   Informatica,

---

To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  

---

What are the designer tools for creating transformations?

0 Answers   Informatica,

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 Answers   Zensar,

---

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

---