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 are the data movement modes in informatica?

0 Answers   Informatica,

---

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

---

Define pmcmd command?

0 Answers  

---

What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,

---

why do u use shortcuts in informatica.?

4 Answers   iFlex,

---

What is hash partition?

2 Answers  

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

0 Answers  

---

What are events in workflow manager?

1 Answers   Accenture, IBM,

---

What is the function of aggregator transformation?

0 Answers  

---

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

0 Answers  

---

What happens when a session fails and you click on recover?

0 Answers  

---

how to run the batch using pmcmd command

2 Answers   Wipro,

---