Why touse stored procedure in ETL Application?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the informatica performance improvement tips

619


What is an Integration service in Informatica?

708


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

637


What are the limitations of joiner transformation?

657


How we can use union transformation?

614






wat are deployement groups in informatica, how it will be used for developers

1263


Can we change Dynamic to Static or Persistent cache? If so what happens?

1731


How can you define user defied event?

626


What is the sql query overwrite in source qualifier in informatica

623


Explain lookup transformation is active in informatica

667


Why is sorter an active transformation?

667


What is incremental aggregation?

577


What is the use of target designer?

612


How to Create a folder using pmrep command?

626


What is a surrogate key?

563