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,

1401

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

1268

What is granularity? Please explain with example

IBM,

1 2158

Explain me ETL project architecture in Detail?

Infosys,

2371

In Which Transformation We Can Use Having Clause In Informatica?

1242

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

IBM, Saama Tech, Wipro,

1 1899

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

IBM, Saama Tech, Wipro,

1264

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

IBM, Saama Tech, Wipro,

1197

How to delete data which is not in source table?

IBM, Saama Tech, Wipro,

1338

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

IBM, Saama Tech, Wipro,

1 2433

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 3792

What is data modeling and data mining?

975

What are the ETL Testing Operations?

1049

Explain the use lookup tables and Aggregate tables?

977

What is data cleaning?

942

Post New ETL Questions

Un-Answered Questions { ETL }

where are the log files generally stored.Can you change the path of the file.what can the path be?

2441

How many types of transformations supported by sorted input?

1224

Define slowly changing dimensions (SCD)?

1060

what is an ETL or ETT? And what are the different types?

7496

Difference between flat files and relational sources?

2309

how do u really know that paging to disk is happening while u are using a lookup transform?

1986

what are the reporting tools and difference between them?

2092

hoe to access second value in mapping parameter if it is having more than one value ?????????????

1539

how do u really know that paging to disk is happening while u are using a lookup transform?

2428

When do we analyze the tables? How do we do it?

960

how does the server recongnise the source and target databases.Elaborate on this

2691

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

2199

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

1998

how many maximum session supports to multiload in teradata ??

2118

What is partitioning? Explain about round-robin, hash partitioning.

968

For More Un-Answered { ETL } Questions Click Here