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

What is dimensional table?

794


What are the different versions of informatica?

942


What do you mean by filter transformation?

743


What is rank index in rank transformation?

803


Performance tuning( what you did in performance tuning)

1709


What are the new features of Power Center 5.0?

1429


What is a connected transformation?

873


What can we do to improve the performance of informatica aggregator transformation?

842


During the running session, output files are created by informatica server. Enlist few of them.

747


Explain lookup transformation in informatica

825


what are 3 tech challenges/ common issues you face?

2098


What is an aggregator transformation?

819


Why do we need informatica?

726


What are the main features of Oracle 8i with context to datawarehouse?

1869


Sequence generator, when you move from develoment to production how will you reset

1647