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.
Why do normalized tables need more complex SQL when SQL statements are employed in application programs?
Give a brief introduction of the term ‘SQL Server 2005 Analysis Services’ (or SSAS)?
What do you understand by the term Dataset?
Explain the Filter transformation?
Write down a short note on the functions of a reporting system?
To implement the priority queue what is the minimum number of queues we need?
Explain the types of jobs we have within the Data stage?
Briefly define and describe the term data constraints?
Explain the relationship between JDBC and Sybase.
Explain the term local container and shared container?
18,76,764
1931819 Asked
3,689
Active Tutors
1412242
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!