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

Explain the use lookup tables and Aggregate tables?

0 Answers  


IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.

3 Answers   TCS,


diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

0 Answers   L&T,


Explain about etl data integration software?

0 Answers  


What is cube grouping?

0 Answers  






How can we use external procedural logic in informatica?

0 Answers  


what is dynamic insert?

0 Answers  


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?

1 Answers  


working of line item dimension......pls,tell overall flow

1 Answers  


can be used COM component in Informatica ?

0 Answers  


What is a materialized view log?

0 Answers  


what are the concerns of OLTP and DSS systems?

0 Answers   TCS,


Categories