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

ETL Interview Questions

Questions Answers Views Company eMail

what are the facilities provided by data warehouse to analytical users?

2009

what are the facilities provided by OLAP to analytical users?

1 4637

what is HISTOGRAM? how to generate statistics?

1 4883

how do u set the size of block buffer?

1 4327

how do u implement unconn.stored proc. in a mapping?

1 4812

if u can't find what you are looking for in lookup table, how do you handle?

1 5165

How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)

1 6049

Which type or t/s is used to convert rows into column & column into rows

Infosys,

9 29318

In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.

Accenture,

3 8994

Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com

Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,

320 275323

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

2181

Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 7055

Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?

2 6834

architural difference between 7.1 workflow monitor and 8.1 workflow monitor.

IBM, Infosys,

1 3674

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2488

Post New ETL Questions

Un-Answered Questions { ETL }

How can we use external procedural logic in informatica?

873

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

2119

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

2077

What is partitioning? Explain different types of partitioning?

1159

how many maximum session supports to multiload in teradata ??

2042

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

1016

Difference between flat files and relational sources?

2176

what is Forward,Reverse and Re_engineering?

2128

Explain about etl data integration software?

843

What are the ETL Testing Operations?

988

Explain the use lookup tables and Aggregate tables?

929

What is the difference between project backlog and product backlog?

1444

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

1135

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

2964

what happens if the info.server doesn't find the session parameter in the parameter file?

1881

For More Un-Answered { ETL } Questions Click Here