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.
Which of the following method does not support sorting (Exchange, Selection, Insertion, Deletion)?
Write about stage administrator and manager?
Why is modeling time-dependent data important with a time stamp?
Explain the reusable transformation?
List out the various schemas which are supported by the BO Designer?
Write down the brief note on the differentiations between Normalizer and Normalizer transformation?
Name the triggers which support SQL Server 2000?
Explain the term optimization and performance tuning and its work in practical projects?
Write down a short note on the term concurrency transparency?
Briefly describe the new features of SQL Server 2005 Analysis Services (or SSAS)?
18,76,764
1924411 Asked
3,689
Active Tutors
1421296
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!