Rank-Router-Sorter transformation
Explain the Rank, Router, Sorter transformation?
Expert
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.
Briefly describe the employ of aggregate tables and lookup tables?
Explain what is meant by the repository and what does it consists of?
Write a short note on an ERD?
Describe why stored procedures decreased network traffic.
Explain the way to select tables for partition in Sybase?
Explain how one source columns or the rows may be loaded within the two different tables?
You have two tables, STUDENT and COMPUTER which are in a one-to-one relationship. The foreign key is StudNumber in COMPUTER that references StudNumber as the primary key of STUDENT. Describe what must be done to convert the one--to-one STUDENT -COMPUT
What are the catches?
Specify the types of connections we use while connecting with the database?
Describe briefly the alternative terminology which is employed in the relational model?
18,76,764
1954727 Asked
3,689
Active Tutors
1460696
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!