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.
Specify the types of dimensions which are available in the Informatica?
Explain the term Data mart?
Illustrate the term indexing. Specify the kinds of the indexing.
Illustrates the uses of C++ in Clipper?
Explain the term Coalesce. Answer: Coalesce is also obtainable in Sybase, this function estimates the listed expressions and returns the first non-null value.
Illustrates the relationship between a queue and underlying array of data structure?
What do you understand by the term foreign key in DBMS, and why is it employed for?
Explain what is meant by the repository and what does it consists of?
Determine the stand-alone procedures?
What are the kinds of files employed in Oracle recovery?
18,76,764
1924437 Asked
3,689
Active Tutors
1447294
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!