Why touse stored procedure in ETL Application?
- 2 Answers
- 10616 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / grhyrngnn yjhyj
i used to stored procedure for time conversion,droping and
creating indexes,for loading time dimension,to know the
status of the database,to know the space availble.
| Is This Answer Correct ? | 5 Yes | 0 No |
What are the features of complex mapping?
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
Define informatica repository?
what is data modelling? what are types of modelling?In which suituation will use each one?
what transformations are used for Variable port?
Why do we use DSS database for OLAP tools?
how will compare two mappings in two different repository?
Where can we find the throughput option in informatica?
What do think which one is the better joiner or look up?
how to delete duplicate records by using filter transfermation?
What are the mapping paramaters and mapping variables?
Is it possible to have "5 source & 5 Target" in single mapping?
Teradata 
