Stored-procedures and its advantages
Explain about the stored-procedures and its advantages.
Expert
Stored procedures are database objects which perform a user defined operation.
Well a stored procedure can contain a set of compound SQL statements. It executes the SQL commands and returns the product to the client. All stored procedures are utilized to decrease network traffic.
Explain the term Container and also its types?
Illustrates the levels of data abstraction?
Contrast a network and hierarchical database model?
State the different advantages of the data warehousing?
Illustrates the Radix Sort?
Write down a short note on XML and also describe the uses of it?
Elucidate Where to keep informatica rejected data? How to remove the informatica rejected data?
Explain about the Active and Passive Stage?
What occurs while rows are determined using a FETCH statement?
How can we do unit testing into the informatica? How to load data in the informatica?
18,76,764
1922731 Asked
3,689
Active Tutors
1439048
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!