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.

how can we run workflow with pmcmd?

3 Answers   Wipro,

---

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

---

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

---

What could be the possible resons of locks by user?

0 Answers  

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

Target increases every day even though no new record was inserted

0 Answers   Accenture,

---

How informatica process data means how informatica works?

2 Answers   TCS,

---

what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,

---

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?

9 Answers   IBM,

---

Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers   Infosys,

---