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 can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

---

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,

---

Explain transaction control transformation in informatica

0 Answers   Informatica,

---

What is a parameter When and where do you them when does the value will be created

0 Answers  

---

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers   HP,

---

---

In informatics server which files are created during the session rums?

0 Answers  

---

What is junk dimention?

3 Answers   Patni,

---

What is an Integration service in Informatica?

0 Answers  

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  

---

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

---

What is Datadriven?

2 Answers   Informatica,

---