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 is the meaning of up gradation of repository?

0 Answers  

---

how i will stop my workflow after 10 errors

1 Answers   HP,

---

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,

---

Why use the lookup transformation ?

2 Answers   Informatica,

---

Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 Answers  

---

What is data caches/ index caches?

0 Answers  

---

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

---

What are parallel querys and query hints?

1 Answers  

---

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,

---

when informatica 8 series released ?

1 Answers   IBM,

---

How can you recover the session in sequential batches?

1 Answers  

---

What is source qualifier transformation in informatica?

0 Answers  

---