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 master-detail report

Patni, TCS,

3 15702

whats the diff between break and section

TCS,

4 10629

what is universe null

TCS,

1 2472

what is the filter?

1 5243

As im new to BO, tel me 1.How to do migration from BO6.5 to BOXIR2? 2.whats the difference b/w BO6.5 to BOXIR2. 3. whats the way both BO 6.5 n BOXIR2 file storge varies.

Cap Gemini,

5 12142

Is it possible to generate reports without having knowledge of the Universe structure?

4 7484

i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records. How is it possible?

Tech Mahindra,

4 10272

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

Infosys,

1 2154

In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Genelally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my problem,,,,,

Tech Mahindra,

2 7897

How can you create prompts in framework manager?

Tech Mahindra,

4 25056

What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?

3 7311

what is the difference between count and running-count functions?

1 16982

How much time it will take to develop a report in real time? It depends upon the complexity of the report, so tell me the approximate time period for a simple list, cascading, master-detail, drill-through,..…etc?

3 6905

How can we improve performance in report studio level?

1 6682

How can we improve performance in framework manager level?

Wipro,

3 13261

Un-Answered Questions { Data Warehouse }

What r the names of the reports that you prepared?

1029

Explain in detail about scd type 1 through mapping.

1646

What is rollup component?

1330

What are the data types present in bo? What happens if we implement view in the designer and report?

1082

What is dimensional table? Explain the different dimensions.

1267

What is a rollup component? Explain about it.

1241

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

2421

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2261

EXL informatica Questions

1460

What is dimensional table?

1162

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3660

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

4260

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

1769

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

1146

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

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