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

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1466


tell me 5 session failure in real time how can you solve that in your project?

1634


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1644


What is domain and gateway node?

699


What are the differences between source qualifier and joiner transformation?

602






What is different between the data warehouse and data mart?

630


Design a mapping to load a target table with the following values from the above source?

883


What happens when a session fails and you click on recover?

657


Where can we find the throughput option in informatica?

600


Explain the informatica workflow?

590


What are batches?

623


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1074


How can we store previous session logs?

569


What is an active transformation?

648


How we can create indexes after completing the loan process?

729