Interested to Buy Any Domain ? << Click Here >> for more details...
Why touse stored procedure in ETL Application?
- 2 Answers
- 11907 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 a table it has 200 rows the query is select 150 from tablename.whats the output
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Can u generate reports in Informatica?
what is Active lock explain
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
What are the static cache and dynamic cache in informatica?
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
Where are the source flat files kept before running the session?
what is the need of session partitioning... how it is useful in real time
What are the scheduling options to run a sesion?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
What is confirmed fact in dataware housing?
Teradata 
