What are the types of data that passes between informatica
server and stored procedure?



What are the types of data that passes between informatica server and stored procedure?..

Answer / swetha

3 types of data

Input/Out put parameters

Return Values

Status code.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Informatica Interview Questions

How can you run a session without using server manager?

1 Answers  


What are the tasks that source qualifier performs?

1 Answers  


Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,


I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,


How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,


What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,


Clarify the utilization of aggregator cache record?

0 Answers  


Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,


What are the scheduling options to run a sesion?

2 Answers  


What are batches?

0 Answers  


what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,


Categories