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.
In OLE DB, what is the difference between an implementation and an interface?
Explain the difference between expression and aggregator?
Can we have a report with several data providers?
Give a brief introduction of the term analysis service?
Explain the uses of stored procedure?
Explain what is meant by the WebI or Web Intelligence?
Reduction in Cost: Huge reduction in costs can be achieved due to cloud computing both in terms of capital expenditure and operational expenditure. Since the organization now need not build its own
Explain for what the Supervisor module is used?
State the use of data stage jobs?
Briefly describe the fundamental stages of Data Warehousing?
18,76,764
1950515 Asked
3,689
Active Tutors
1449431
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!