Why touse stored procedure in ETL Application?
- 2 Answers
- 10665 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 |
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
I have a flat file, want to reverse the contents of the flat file
What is a node in Informatica?
Why you use repository connectivity?
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
wf dont have integration severances how you can run?
Explain about HLD and LLD ?
what is degenerated dimension
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
What are the data movement modes in informatcia?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
Teradata 
