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,

1 1471

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

1 1327

What is granularity? Please explain with example

IBM,

1 2302

Explain me ETL project architecture in Detail?

Infosys,

1 2426

In Which Transformation We Can Use Having Clause In Informatica?

1 1317

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

IBM, Saama Tech, Wipro,

1 2000

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

IBM, Saama Tech, Wipro,

1 1326

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

IBM, Saama Tech, Wipro,

1 1265

How to delete data which is not in source table?

IBM, Saama Tech, Wipro,

1 1405

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

IBM, Saama Tech, Wipro,

1 2538

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 3913

What is data modeling and data mining?

1 1038

What are the ETL Testing Operations?

1 1116

Explain the use lookup tables and Aggregate tables?

1 1039

What is data cleaning?

1 1020

Post New ETL Questions

Un-Answered Questions { ETL }

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4192

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2104

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1769

what are the data modeling tools you have used?(polaris)

2057

For More Un-Answered { ETL } Questions Click Here