Remove duplicate rows from flat file
How can we remove duplicate rows from the flat file?
Expert
Use Sorter Transformation. When we configure Sorter Transformation to treat the output rows as distinct, it configures overall ports as part of sort key. It thus abandons duplicate rows compared through the sort function.
Give a brief introduction of the term SAS Business Intelligence?
State difference between the Stand–alone and the Embedded filter?
Describe any two reasons which show the necessity of database redesign?
Illustrates the term normalization?
Specify the designer tools used for creating the tranformations?
Give a brief introduction of the term data mining and data modeling? In what manner both the termed are used?
Explain terms Data Cache in Sybase. Answer: It is the memory area where data which is required for the current queries running is bought by Disk upon to memory for
Write down the working procedure of Online Databases.
Give a brief introduction of the term ‘SQL Server 2005 Analysis Services’ (or SSAS)?
What types of tables derived from the ERD?
18,76,764
1951020 Asked
3,689
Active Tutors
1430573
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!