Why we use stored procedure transformation?
Answers were Sorted based on User's Feedback
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 |
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 sorter is an active transformation?
Can we get 1st record through Informatica(without sequence number).
how can one come to know wether the records loak into the target if we use update strategy
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Limitation of REPLACESTR. Is there any character limitation to it.
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.
How to delete the data in the target table after loaded.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is data movement mode in Informatica and difference between them?