what r the values tht r passed between informatics server
and stored procedure?



what r the values tht r passed between informatics server and stored procedure?..

Answer / sai suresh

There are 3 types of data passing between informatica
server and stored proceduer these are
Input/Output parametors: Stored procedure it receive the
inputs and porvied the outputs.
Return Value:Ever data base to provied return value after
processing of stored procedure.
Status code: It is used for error handling.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

Can we update the data in flat file using update strategy?

3 Answers  


can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,


What is the scenario which compels informatica server to reject files?

0 Answers  


In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  


what is mapping performence?

2 Answers   Cap Gemini,






I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  


What is xml source qualifier transformation in informatica?

0 Answers  


Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,


What is expression transformation?

0 Answers  


What is workflow manager?

0 Answers  


In which scenario did you used pushdown optimization?

1 Answers  


Categories