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 |
what is the meant by Normalization and de-normalization?
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
what are Lookup caches options? Including persistent caches.
What is partitioning? Explain about round-robin, hash partitioning.
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
Identifying the bottlenecks in various components of Informatica and resolving them.
Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.
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.
what is the difference steps for data modeling?
dimension object created in oracle can be imported in designer?how?
What are the steps involved in etl process?
Do we need an ETL tool? When do we go for the tools in the market?