Interested to Buy Any Domain ? << Click Here >> for more details...
Why touse stored procedure in ETL Application?
- 2 Answers
- 11936 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 measure objects?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the different transaction levels available in transaction control transformation?
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
What are the new features of the server manager in the informatica 5.0?
What are the basic needs to join two sources in a source qualifier?
Difference between task flow and linear task flow
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
How to identify this row for insert and this row for update in dynamic lookup cache
Teradata 
