Which will beter perform IIf or decode?
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 |
What are the differences between a connected lookup and unconnected lookup?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
How do you manage the Parameter files while migrating your data from one environment to another environment?
how to obtain performance data for individual transformations.
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
Can you create a flatfile target
Can we update the data in flat file using update strategy?
Diffrence between 7.1,8.1 and 8.6
What are Target Options on the Servers?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?