Why touse stored procedure in ETL Application?

Answer Posted / susheel sharma

in our project we used store procedure to implement CDC
(change data capture) for incremental data load.

generaly store procedure used when you have to implement
your complex business logic.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use pmcmd utility command?

684


What is meant by lookup transformation?

697


What is different between the data warehouse and data mart?

716


Can informatica load heterogeneous targets from heterogeneous sources?

814


Explain sql transformation in script mode examples in informatica

685






What could be the possible resons of locks by user?

747


Performance tuning in UNIX for informatica mappings?

2246


what are 3 tech challenges/ common issues you face?

1980


What do you understand by a term domain?

768


can you please explain me pre session and post session options?

6623


What are the limitations of joiner transformation?

746


Mention few power centre client applications with their basic purpose?

620


Explain joiner transformation in informatica

770


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1955


What do you understand by SOA of Informatica?

668