Why we use stored procedure transformation?

Answer Posted / rajbir

We use stored procedure transformation top evalate the
expression for rows at database level so that we can use it
again n again according to our requirment

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to load rows into fact table in data warehouse

915


What is a node in Informatica?

832


What is exclusive and normal mode for repository services?

923


lookup transformation with screenshots

3783


How can you generate reports in informatica?

794


Where do we use mapping variables in informatica?

832


What is aggregate cache in aggregator transformation?

860


How to open an older version of an object in the workspace?

877


What the difference is between a database, a data warehouse and a data mart?

879


What are the different lookup cache(s)?

851


Where is metadata stored?

808


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8040


How can we remove the duplicates from flat file source?

805


generate date / time dimension in informatica

917


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1872