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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the names of the layers in etl?

533


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

522


How to increase performance without changing anything in mapping.( In prod)

780


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

1503


what happens if the info.server doesn't find the session parameter in the parameter file?

1537






How many steps etl contains explain with example?

473


please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2025


what is the main role of FI on business

1623


hoe to access second value in mapping parameter if it is having more than one value ?????????????

1128


What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

649


what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2162


What are the key benefits of ETL Testing?

563


What is tracing level and what are the types?

531


Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1467


what is the meant by Normalization and de-normalization?

2230