Explain the Rank, Router, Sorter transformation?
Rank transformation is defined as an Active and Connected transformation. It is used in order to select the top or bottom rank of the data.
Router transformation refers to an Active and Connected transformation. It is same as that of the filter transformation with the difference that, filter transformation drops the data which do not meet condition on the other hand router has another option to capture the data which do not meet the condition. It is useful to test various conditions.
Sorter transformation is defined as a Connected and an Active transformation. It enables to sort the data either in the ascending or descending order as per the specified field.
Illustrates the case statement present into stored procedure?
Explain the Aggregate Awareness?
Justify whether all the Business Objects users build the data providers?
Specify the data units at the different layers of TCP / IP protocol suite?
Contrast a fat and a thin client?
What is Enterprise Resource Planning (or ERP), and what type of a database is employed in an ERP application?
Briefly explain the Dashboard in the business intelligence?
Define the term OCI?
Explain how is the HASH file used and where we can use it?
Specify the other areas for the purpose of Data warehousing and the data mining.
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!