Interested to Buy Any Domain ? << Click Here >> for more details...
Why touse stored procedure in ETL Application?
- 2 Answers
- 11746 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 |
PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U
What is aggregate cache in aggregator transforamtion?
Define maping and sessions?
In any project how many mappings they will use(minimum)?
how to run 2 workflows sequentially. plz respond what is the process?
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
What are the data movement modes in informatica?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
What is an expression transformation in informatica?
What is status code?
When you move from devel to prod how will you retain a variable
According to his methodology what all you need before you build a datawarehouse
Teradata 
