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?

2029

what are the facilities provided by OLAP to analytical users?

1 4662

what is HISTOGRAM? how to generate statistics?

1 4916

how do u set the size of block buffer?

1 4347

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

1 4838

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

1 5192

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

1 6079

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

Infosys,

9 29395

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 9029

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 278016

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

2195

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 7091

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

2 6866

architural difference between 7.1 workflow monitor and 8.1 workflow monitor.

IBM, Infosys,

1 3699

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

2500

Post New ETL Questions

Un-Answered Questions { ETL }

can be used COM component in Informatica ?

2029

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

1923

Explain the use lookup tables and Aggregate tables?

943

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

1235

What is a mapping?

946

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3731

What is a staging area? What is the purpose of a staging area?

832

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

1686

1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

2078

Explain about the data integration suite features?

897

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?

2137

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

2973

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

2387

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1981

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

2649

For More Un-Answered { ETL } Questions Click Here