This Question is not yet answered!

•   Over vs runs -- same sequence number for each group
•   Volage contol and current control
•   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

•   How to read 5 input file (having completely different format) using sequential file stage?
•   How to load different metadata file from source to different target in single job
•   Write multiple files
•   Selection sort
•   Rdbms
•   Drop a table and its child tables from a database using procedure
•   Problem statement: hope you love watching movies! Goto any online ticket booking website and write various test scenarios (at least 20) of the most common functionalities of the site. You need to crea
•   Rank transformation type and range by partition
•   Find 2 highest salary from each depart who have completed 5 years in org.
•   Ah and esp