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

ETL Interview Questions

Questions Answers Views Company eMail

How many types of transformations supported by sorted input?

1222

How to fine tune mappings?

941

What is a mapping, session, worklet, workflow, mapplet?

985

What is etl process?

936

What is tracing level? How many types of transformations supported by sorted input?

973

Explain what are the various etl tools in the market?

946

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

949

Explain do we need an etl tool? When do we go for the tools in the market?

1013

Explain do we need an etl tool?

1016

When do we go for the tools in the market?

947

Explain what is etl process? How many steps etl contains explain with example?

893

How many steps etl contains explain with example?

970

Explain and compare etl & manual development?

926

Explain the difference between etl tool and olap tools?

908

What are various etl tools in the market?

1008

Post New ETL Questions

Un-Answered Questions { ETL }

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

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1965

What is a mapping?

987

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

1264

What is fact? What are the types of facts?

1117

can be used COM component in Informatica ?

2059

what is pmrep command?

2434

what is session partitioning?

1879

what are the session parameters? How do u set them?

2047

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

964

how would u estimate the size of Aggregator transform data and index cache?

1961

what is the meant by Normalization and de-normalization?

2718

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

2236

Explain about enterprise scalability and roi of data integration suite?

879

What are the different etl testing categories as per their function?

1076

For More Un-Answered { ETL } Questions Click Here