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
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 the difference between a repository server and a powerhouse?
what is the size of u r source(like file or table)?
Define mapping and session?
Clarify the utilization of aggregator cache record?
Clarify the aggregator change?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is workflow? What are the components of workflow manager?
How does a sorter cache works?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Explain what transformation and how many are there in informatica?
Explain constraint based loading in informatica
What is incremental aggregation?
Explain why we use partitioning the session in informatica?
What is the different lookup cache(s)?
