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,

1344

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

1224

What is granularity? Please explain with example

IBM,

1 2062

Explain me ETL project architecture in Detail?

Infosys,

2312

In Which Transformation We Can Use Having Clause In Informatica?

1167

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

IBM, Saama Tech, Wipro,

1 1799

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

IBM, Saama Tech, Wipro,

1204

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

IBM, Saama Tech, Wipro,

1135

How to delete data which is not in source table?

IBM, Saama Tech, Wipro,

1269

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

IBM, Saama Tech, Wipro,

1 2341

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 3662

What is data modeling and data mining?

919

What are the ETL Testing Operations?

988

Explain the use lookup tables and Aggregate tables?

929

What is data cleaning?

889

Post New ETL Questions

Un-Answered Questions { ETL }

Can we create Hierarchies in generic datasources?

2328

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1748

What are materialized views & where do we use them?

918

What is a lookup table in etl?

1107

What is initial load and what is full load?

903

Do we need an ETL tool? When do we go for the tools in the market?

892

how do u set partition points in the mapping?

2527

how do u implement configuration management in Informatica?

4732

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2434

Compare ETL & Manual development?

897

Explain about power designer data modeling software?

801

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.

2155

How can we use external procedural logic in informatica?

873

Can anyone explain me a scenario from banking and finance...more precisely a mapping

2444

if i have a query as flat file how can we load data to target table

1338

For More Un-Answered { ETL } Questions Click Here