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 is the meant by Normalization and de-normalization?

0 Answers  


how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

0 Answers  


what are Lookup caches options? Including persistent caches.

0 Answers  


What is partitioning? Explain about round-robin, hash partitioning.

0 Answers  


Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 Answers  


Identifying the bottlenecks in various components of Informatica and resolving them.

0 Answers  


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

3 Answers   TCS,


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  


what is the difference steps for data modeling?

0 Answers  


dimension object created in oracle can be imported in designer?how?

0 Answers  


What are the steps involved in etl process?

0 Answers  


Do we need an ETL tool? When do we go for the tools in the market?

0 Answers  


Categories