Interested to Buy Any Domain ? << Click Here >> for more details...
Why touse stored procedure in ETL Application?
- 2 Answers
- 11898 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 |
Design time, run time. If you don't create parameter what will happen
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
What is meant by active and passive transformation?
how do u fnd the duplicate rows and how to delete the duplicate rows?
What is a joiner transformation?
how to convert the .doc docs into .txt format using informatica
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
How informatica process data means how informatica works?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
Teradata 
