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

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,


(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 Answers  


In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,


sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  


source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,


My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,


How to improve the performance of Aggregate transformation?

3 Answers   Dmss,


what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,


Informatica and datawarehousing courses in Pune?

2 Answers  


what are the perameter and variable?

3 Answers   IBM,


Explain grouped cross tab?

1 Answers   Accenture,


How do you do error handling in Informatica?

1 Answers  


Categories