Why we use stored procedure transformation?

Answers were Sorted based on User's Feedback



Why we use stored procedure transformation?..

Answer / anilchandu

Instead of writing complex logics in expression t/r we will
use Stored procedure t/r.

The main advantage of stored procedure t/r is the code
reusability.

Is This Answer Correct ?    10 Yes 0 No

Why we use stored procedure transformation?..

Answer / swetha

For populating and maintaining data bases.

Is This Answer Correct ?    3 Yes 2 No

Why we use stored procedure transformation?..

Answer / 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

Why we use stored procedure transformation?..

Answer / madhu

For best performance

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Informatica Interview Questions

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,


my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?

4 Answers   Mind Tree, Polaris,


what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,


how to load rows into fact table in data warehouse

0 Answers   Informatica,


Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  






How to load last 10 records of flat file in to the target?

5 Answers   iNautix,


How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,


HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,


Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers   Cognizant, Wipro,


What are the new features in Informatica 5.0?

1 Answers  


in which situations do u go for sequence generator ?

2 Answers   TCS,


my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

5 Answers   IBM,


Categories