This Question is not yet answered!

•   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
•   Load different data files in single target table
•   Dynamic target creation using source data
•   Error while inserting records into table
•   Use of nocopy in procedure
•   Create session log as a parameter in Informatica cloud
•   Chart of account segments
•   SCD insert, update and link data
•   Why do we need package?

•   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.
•   Create package body with one priVATe subprogram only without package specification
•   Create delta file in jcl
•   Update a table using multiple join conditions
•   Testing cruise line dining.
•   Test scenarios for 'create and send email' functionality