Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are Dimensional table?
What are the transformations that are not supported in mapplet?
How you prepared reports for OLAP?
scenario where i can use only concurrent execution of workflow.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How can we improve session performance in aggregator transformation?
What are the designer tools for creating transformations?
Design a mapping to load the cumulative sum of salaries of employees into target table?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the different versions of informatica?
What is enterprise data warehousing?
Please let me know how to make Data masking in informatica..
How an expression transformation differs from aggregator transformation?
What is the benefit of partitioning a session?
