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

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

Explain what is the difference between microstrategy and cognos reporting tool?

1 1179

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1 1185

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1 1197

Explain what is informatica metadata and where is it stored?

1 1127

How to use procedural logic inside infromatica?

1 1355

What is informatica metadata and where is it stored?

1 1072

How to call shell scripts from informatica?

1 1063

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1 1188

Is there any way to read the ms excel datas directly into informatica?

1 1089

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1 1143

Explain the different lookup methods used in informatica?

1 1111

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1 1074

Explain what are the different versions of informatica?

1 1166

How to extract sap data using informatica? What is abap? What are idocs?

1 1294

What are the different versions of informatica?

1 1375

Un-Answered Questions { Data Warehouse }

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2311

Explain about a time when you discovered a more efficient way to do a work task?

1222

What is rollup component?

1330

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1042

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1199

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1962

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2546

What is dimensional table?

1162

What is dimensional table? Explain the different dimensions.

1267

Have you have ever worked in unix environment and why it is useful in datastage?

1214

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2334

Demonstrate experience in maintaining quality process standards?

2672

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2792

For More Un-Answered { Data Warehouse } Questions Click Here