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 is intricate mapping?

794


How to differentiate between the active and passive transformations?

835


What are pre and post-session shell commands?

993


Different qualification between a related rotate toward the sky and isolates look upward?

765


What is the difference between Active and Passive transformation?

851


Differentiate between reusable transformation and mapplet.

841


What are the components of Informatica? And what is the purpose of each?

815


Write the unconnected lookup syntax?

831


What is main use of mapplet?

864


What is the sql query overwrite in source qualifier in informatica

827


How many input parameters can exist in an unconnected lookup?

1271


Which files are created during the session rums by informatics server?

918


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1901


Scheduling properties,whats the default (sequential)

1673


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1914