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 is target designer and target load order?
How many input parameters can exist in an unconnected lookup?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is meant by target load plan?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Define filter transformation?
What is workflow manager?
What is a joiner transformation and why it is an active one?
Explain what is informatica metadata and where is it stored?
How to join three sources using joiner? Explain though mapping flow.
What is the benefit of partitioning a session?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What could be the possible resons of locks by user?
can u any challenge your project?