Which will beter perform IIf or decode?

Answer Posted / venkat

decode is better perform than iff condtion,decode can be
uesd insted of using multiple iff cases

Is This Answer Correct ?    26 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are some examples of informatica etl programs?

544


What is a predefined event?

672


Explain the different lookup methods used in informatica?

599


Explain the use of aggregator cache file?

693


On which transformations you created partitions in your project?

765






How might one distinguish in the case of mapping is right or not without associating session?

648


What is incremental aggregation?

583


permutations of mapplet

2048


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1704


During the running session, output files are created by informatica server. Enlist few of them.

550


explan ur project architecture?

1605


What is substr in informatica?

675


What is sequence generator transformation in informatica?

639


How to use pmcmd utility command?

595


Explain in detail about scd type 1 through mapping.

599