how do u implement unconn.stored proc. in a mapping?



how do u implement unconn.stored proc. in a mapping?..

Answer / sarvesh

unconn.stored procedure is implemented by the exprression
transformation as :sp.proc2(sal,proc_result),here proc2 is
the procedure name

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More ETL Interview Questions

what are the different Reporting and ETL tools available in the market?

3 Answers  


How many types of transformations supported by sorted input?

0 Answers  


how do u handle performance issues in Informatica . where can u monitor the performance ?

0 Answers  


you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.

3 Answers  


How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

0 Answers   IBM, Saama Tech, Wipro,






what is the main role of FI on business

0 Answers  


what are the session parameters? How do u set them?

0 Answers  


Is hadoop a etl tool?

0 Answers  


how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

0 Answers  


Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

0 Answers  


Can anyone explain me a scenario from banking and finance...more precisely a mapping

0 Answers   IBM,


Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.

3 Answers   TCS,


Categories