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?

2077

what are the facilities provided by OLAP to analytical users?

1 4718

what is HISTOGRAM? how to generate statistics?

1 5005

how do u set the size of block buffer?

1 4403

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

1 4910

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

1 5246

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

1 6162

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

Infosys,

9 29696

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 9139

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 283301

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

2234

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 7199

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

2 6947

architural difference between 7.1 workflow monitor and 8.1 workflow monitor.

IBM, Infosys,

1 3758

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

2536

Post New ETL Questions

Un-Answered Questions { ETL }

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

1191

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

7493

what is the use of structures?how many nodes can u create in a structure?

2237

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

1071

what is session partitioning?

2119

What are the modules in Power Mart?

957

Define slowly changing dimensions (SCD)?

1051

What are the differences between sql override and update override?

1097

Explain the key challenges that you face while performing etl testing.

1004

What is lookup table in etl testing?

1182

what is data modeling?

1905

What is meant by incremental load?

1092

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

931

Give the benefits of data integration suite?

918

What are your responsibilities as an etl tester?

1152

For More Un-Answered { ETL } Questions Click Here