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

What is the difference between Data Level Security and Object Level Security?

1 4574

How do you implement security using External Tables and LDAP?

1 3020

If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?

1 3009

If you want to create new logical column where will you create (in repository or dashboard) why?

1 2567

What is complex join, and where it is used?

1 2626

If you want to limit the users by the certain region to access only certain data, what would you do?

1 2828

If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?

1 2934

How do implement event polling table?

1 3206

Define pipeline. Did you use it in your projects?

1 2734

How do you work in a multi user environment? What are the steps?

1 2577

Can you bypass siebel analytics server security ?if so how?

1 2579

What are the things you can do in the BMM layer?

1 2804

What is the difference between Single Logical Table Source and Multiple Logical Table Sources?

1 5335

How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?

1 2546

How do you know which report is hitting which table, either the fact table or the aggregate table?

1 2678

Un-Answered Questions { Data Warehouse }

how to generate the test data in sas without input data? : Sas-administrator

1207

How to create the source and target database connections in server manager?

1144

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1998

How would you format some text using css to be verdana and bold?

1150

What is the purpose of Dataware Control?

1121

What is dimensional table?

1168

what are the data modeling tools you have used?(polaris)

2060

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2108

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212

What sort of existing documents should business analysts refer to when starting on a new project?

1078

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2095

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2084

what are the dimensions that you have in your current project?list them?

2095

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)

2796

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

2306

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