Which will beter perform IIf or decode?
- 3 Answers
- 17694 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / venkat
decode is better perform than iff condtion,decode can be
uesd insted of using multiple iff cases
| Is This Answer Correct ? | 26 Yes | 1 No |
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.
| Is This Answer Correct ? | 13 Yes | 1 No |
How do you handle decimal places while importing a flatfile into informatica?
what is lookup chache?
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
What are active and passive transformations?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
Informatica and datawarehousing courses in Pune?
1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 Answers CompuSoft, EDS, TCS,
What is deployment group?
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
Difference between task flow and linear task flow
What all are steps in up gradation of Informatica server?
What are the rank caches?
Teradata 
