ETL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

ETL Interview Questions

Questions Answers Views Company eMail

SCD2 will work on only dimension tables as well as fact Table?

Infosys,

1406

Which transformation we use to convert 'NA' to 'Not Available'

1274

What is granularity? Please explain with example

IBM,

1 2173

Explain me ETL project architecture in Detail?

Infosys,

2379

In Which Transformation We Can Use Having Clause In Informatica?

1250

Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?

IBM, Saama Tech, Wipro,

1 1909

How to increase performance without changing anything in mapping.( In prod)

IBM, Saama Tech, Wipro,

1269

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

IBM, Saama Tech, Wipro,

1206

How to delete data which is not in source table?

IBM, Saama Tech, Wipro,

1350

What are the different ways to deploy the code in informatica?

IBM, Saama Tech, Wipro,

1 2444

I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

Accenture, Saama Tech, TCS,

2 3807

What is data modeling and data mining?

983

What are the ETL Testing Operations?

1059

Explain the use lookup tables and Aggregate tables?

982

What is data cleaning?

951

Post New ETL Questions

Un-Answered Questions { ETL }

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

2224

Is apache nifi an etl tool?

975

what is the use of server?

2206

What are various etl tools in the market?

1015

tell me few points when u become TL

2568

what is a worklet?

999

Explain the use lookup tables and Aggregate tables?

982

What are the ETL Testing Operations?

1059

Define slowly changing dimensions (SCD)?

1062

What is data cleaning?

951

what is granularity in Data ware House?

1735

Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

2200

What is initial load and what is full load?

993

where we cannot use sorter Transformation. if we use then we will not get correct data?

2206

What are three tier systems in etl?

1071

For More Un-Answered { ETL } Questions Click Here