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 about Prompt with example?

4 11826

What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?

TCS,

2080

How do you test the reports? Explain the Unit testing procedures after developing the reports?

HP, TCS,

1 3322

How to apply securities for reports in cognos connection?

TCS,

2539

1. I have 2 universes. that is u1 and u2. From u1,i created one report that is r1. Now i want to give the connection r1 to u2 and at the same time delete the connection from u1 to r1 ? How is it possible explain? 2.How can i schedule the reports in BOXIR2?

IBM,

4 9426

1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?

KPIT, TCS,

4 25058

how to do page breaks in cognos 8 Report studio pls give the navigation

4 15986

difference between join and union in reportstudio?

IBM,

2 14663

what is the difference between querystudio in reportnet and cognos8

CTS,

2139

When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?

Wipro,

4 8090

When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)?

IBM,

4 8901

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

TCS,

7 13634

what is the monster dimension plz give me one example

EDS,

2 9622

how to run 2 workflows sequentially. plz respond what is the process?

Cap Gemini, Target,

9 28551

Can u please describe the different types of traps with eg. Thanks

2 9315

Un-Answered Questions { Data Warehouse }

what is the cube size?

how will you locate the sas platform applications? : Sas-bi

1035

What is data warehosuing hierarchy?

1179

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2284

Name types of category in which SAS Informats are placed?

1155

Identifying the bottlenecks in various components of Informatica and resolving them.

2622

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1041

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1076

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

1203

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

4198

Can you connect multiload from ab initio?

1225

What is the use of Cognos scenario?

1194

Why does varchar occupy 2 extra bytes?

1201

Mention few test cases and explain them?

934

Why teradata is used?

1011

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