Why we use stored procedure transformation?

Answer Posted / madhu

For best performance

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a grid in Informatica?

605


Tell me about Propagate functions in informatica

520


What is a repository manager?

642


Tell me about MD5 functions in informatica

517


Parameter and variable differences

1613






What are the different options available for update strategy?

570


What is the cumulative sum and moving sum?

748


Explain the etl program with few examples.

539


What is the benefit of session partitioning?

589


What are the components of Informatica? And what is the purpose of each?

613


How to update source definition?

623


explan ur project architecture?

1587


Under which circumstances, informatica server creates reject files?

589


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1245


Separate from a database, an information bazaar, and an information stockroom?

601