Stored Procedure transformation
Explain the Stored Procedure transformation?
Expert
Stored Procedure transformation refers to the Passive & Connected or Unconnected transformation. It is useful in order to automate the time-consuming tasks and it is also used for error handling, to drop and recreate the indexes and to determine space in database, a specialized calculation.
What pointer type will you use while using C language to implement the heterogeneous linked list?
Briefly describe the employ of aggregate tables and lookup tables?
Give a brief differentiation between metadata and data dictionary?
State the different advantages of the data warehousing?
Illustrates the term Table Partitioning in detail? Answer: If you wish for to decrease page contention you do not require multiple devices. You should use multiple d
Write down the differentiation between lookup and filter transformation?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Specify the several types of Strategies?
Describes the examples of EXPLAIN in valid teradata database.
Specify the 2 modes of data movement in the Informatica Server?
18,76,764
1929898 Asked
3,689
Active Tutors
1418589
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!