Oracle

 Truncate vs bulk load vs incremental what is Gtt/temporary tables What is table variables how to call procedure inside procedure how to run concurrent workflows how to run wf inside a workflow

 Mutation error in trigger Delete duplicate rows Autonomous  can we commit/rollback in trigger Can we commit in functions In/OUt/INOUT

 Partitions Delete duplicate rows Indexes Procedure Functions Triggers

 how to get working/non working days in  dynamic sql? How to get data in such a way 1 abc 2 bgf 1   ab 2  bg What are partitions? how to get report to your clients?

 Difference between cursor/implicit/explicit Difference between collection What type of procedure/function Bind variables/Dynamic query materiliazed views collections dml/ddl M-views/Views Indexes can we make indexes on two columns

 What is output of count(*),count(0),count(column) What is output of 1,1,null in case of left join ,outer join ,full join What is dual table What is partitions/hints how to use them How to remove duplicate rows How to get dep wise max salaries

 Difference types of load Performance tuning in informatica How to load a scenario in target where source is 1 10 2 20 3 30

 1 :- SCD type 1/scd type2 /scd type 3 2:- If primary key is not enabled how to load data in target 3:- Lookup

 1:- What is truncate /delete Remove duplicate rows How to get data source 1 a 2  b,d 3 c Target 1 a 1  b 1c 2  a 2 c difference between lookup/unconnected/unconnected Start vs snowflake dimension Degenerated/Conformed dimension Union Transformation SCD type 2

 Hi guys, I am sharing few interview questions of Informatica dev in first Round Of Bank Of America 1:- First Introduction? 2:- what will you do if you need to if your team stuck? 3:- What will you do if you need to complete task in 2 days? 4 :- How to extract first name, middle name in transformation? 5 :- How to remove duplicate in Oracle? 6 :- How to get missing values in target if I miss values in source? 7 :- What is truncate/delete?