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 |
Explain the use lookup tables and Aggregate tables?
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.
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
Explain about etl data integration software?
What is cube grouping?
How can we use external procedural logic in informatica?
what is dynamic insert?
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?
working of line item dimension......pls,tell overall flow
can be used COM component in Informatica ?
What is a materialized view log?
what are the concerns of OLTP and DSS systems?