Answer Posted / 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.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
differences between service based and product based?
Explain lookup transformation in informatica
Write the different tools in the workflow manager?
How to create Target definition for flat files?
When do you use sql override in a lookup transformation?
Clarify the aggregator change?
Can we get 1st record through Informatica(without sequence number).
Differences between connected and unconnected lookup?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain sessions. Explain how batches are used to combine executions?
Global and Local shortcuts. Advantages.
What is domain in terms of informatica?
What is complex mapping?
In informatics server which files are created during the session rums?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
