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 do you understand by the term snapshot replication in DBMS?
You have been given a setup of tables with data and inquired to make a new database to store them. What are you looking for, when you observe the data values in the tables?
Explain the two in order to importing users & groups from the supervisor?
Flexibility due to Cloud computing: Company achieves the flexibility to share data over the clouds. It also gets help in talent acquisition process.
Write down the architectural and functional differentiations between Web Intelligence Reports and business objects?
Illustrates the term natural key in Sybase?
Explain what do you mean by the virtual warehouse?
Who can create up a database or system team? Give a short demonstration of each.
Can you explain how to install an SSIS package?
Explain the term power center repository?
18,76,764
1936637 Asked
3,689
Active Tutors
1443606
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!