Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

How to Create a folder using pmrep command?

0 Answers  


In how many ways we can create ports?

0 Answers  


What is mapplet and a reusable transformation?

2 Answers  


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,


what is filelist concept in informatica

4 Answers  






Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,


What are the differences between a connected lookup and unconnected lookup?

0 Answers  


What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,


Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,


what is the size of ur database(like oracle)

2 Answers   HP,


List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  


I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,






Categories