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.
What is the main dissimilarity between horizontal and vertical partitioning?
Elucidate how many kinds of dimensions are accessible in the Informatica?
Illustrates the basic elements in ER models?
Explain the uses of stored procedure?
Define the term data aggregation?
What are the utilities Oracle gives, which are utilize for backup and recovery?
Illustrate briefly the term SQL sub query?
Explain what is meant by the repository and what does it consists of?
What are sequences, and what are the possible problems when employing them to make surrogate keys?
Briefly describe the fundamental stages of Data Warehousing?
18,76,764
1954142 Asked
3,689
Active Tutors
1433995
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!