This Question is not yet answered!

•   Over vs runs -- same sequence number for each group
•   Need to find the list of employees who is from finance department having 1200 pincode
•   Load a file in Oracle in chunks of 100 MB files
•   How to add header and trailer in a file?
•   How to validate a column, which takes only number and character value?
•   Floor casting
•   Load different data files in single target table
•   Dynamic target creation using source data
•   Data from 1 column to be separated in multiple columns
•   Single column source data

•   Rdbms
•   Drop a table and its child tables from a database using procedure
•   Rank transformation type and range by partition
•   Find 2 highest salary from each depart who have completed 5 years in org.
•   Update a table using multiple join conditions
•   Test scenarios for 'create and send email' functionality
•    Add/modify column changes in facts and dimensions
•   Project and project architecture
•   Find destination field
•   Import complete coloumn values to excel