Answer / chandrasekar

The Stored Procedure Transformation is used to call the
stored procedure.

First, we have to create a Stored procedure in Oracle or SQL
Server.It have 2 types.

one is Connected Stored Procedure and another one is
Unconnected Stored Procedure.

Answer / vas.chiky

for complex results, which we cannot obtain in SQL or from
informatica transformation, we go for procedures.

Also doing the calculation in database level doesnt makes
work load high for our informatica server.

process will be given to database.

Answer / abhinaw prakash

Valid Stored Procedure Use cases
Complex Calculations
If we have a complex calculation that needs to be done for
each record repeatedly we may use stored procedure
transformation. Complex statistical calculations where a
certain measure is being calculated for each of the record
is a good example where one may want to use this.
Performance
There are cases where you may want to use this to improve
your performance. Let’s say one calculation requires
accessing or looking up multiple records or values from
several different tables. If you were to perform this
calculation in Informatica, you will have to perform
multiple lookup operations in many tables. Depending upon
the types of your lookup, this may involve caching the
entire data or at least making multiple network level calls
to transport these data over the network layer. Instead, if
we use a stored procedure transformation, we can perform the
entire calculation within the database, thereby, eliminating
any need to transport data over the network.
Security
Although rare but sometimes client may have a proprietary
algorithm implemented in database. Client does not want to
let others know about the actual algorithm in use, however,
wishes that we take advantage of this algorithm. If the
algorithm is implemented in database stored procedure and
proper access restrictions are placed, then we will not be
able to read the SP to see the algorithm, but still can call
this from Informatica to take the advantage of the
algorithm. Example, proprietary trading algorithms in banks
and brokerage farms.
Reusability
Reusability is a reason why you may want to use a stored
procedure transformation. Suppose you have already written a
complex code in database programming language, tested the
code exhaustively and you are pleased with the performance
of this piece of code. Now that your Organization is
implementing Informatica, you may not wish to rewrite this
entire piece of code in Informatica again. You can reuse
your existing code through stored procedure transformation.

Answer / mallika

For populating and maintaining data bases

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

---

how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,

---

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,

---

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

---

What is session task and command task?

0 Answers  

---

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,

---

How many number of sessions can one group in batches?

0 Answers  

---

What are Dimensional table?

0 Answers   Informatica,

---

What are active transformations.

0 Answers  

---

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

---

How many cubes create from a single model?

1 Answers  

---