Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Explain the mapping variable usage example in informatica

0 Answers   Informatica,


which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,


How can we update a record in the target table without using update strategy?

0 Answers  


i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  


source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,


i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,


How is Data Models Used in Practice?

1 Answers  


Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,


what are surrogate keys?

5 Answers  


What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers   CTS,


How to load duplicate records in to a target table which has a primary key?

2 Answers  


In how many ways we can create ports?

0 Answers  


Categories