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
How we can create indexes after completing the load process?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How can you increase the performance in joiner transformation?
Define update strategy?
What is the Rank index port in Rank transformation?
What is the surrogate key?
Is it possible to create multiple domains on a single Informatica server?
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 is decode in static cache?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What are the components of the workflow manager?
How to go to the older version for a mapping?
What is xml source qualifier transformation in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a grid in Informatica?
