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 a sorter transformation?
How to join three sources using joiner? Explain though mapping flow.
How to generate sequence numbers without using the sequence generator transformation?
How to create Target definition for flat files?
can u any challenge your project?
Why do we need informatica?
What are the types of presistent cache in look up tr.
What is the benefit of session partitioning?
What are ETL Tools?
What is different between the data warehouse and data mart?
What are the settings that you use to configure the joiner transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is a filter transformation and why it is an active one?
How do you load only null records into target? Explain through mapping flow.
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
