scenarios

1. Load last record in a Table
2. Reverse the records of Flat file
3. Separating duplicate and non-duplicate rows to separate tables
4. Count the number of duplicate records
5. Retrieving first and last record from a table/file 
6. Calculate cumulative sum
7. Convert single row from source to three rows in target
8. Split the non-key columns to separate tables with key column in both
9. Load first half records to Target
10. Get top 5 records to target without using rank
11. Sending alternate record to target
12. Separating First Name and Last Name