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 use of surrogate key in businessobjects

EDS,

3 9477

what is sas? is a package or tool? give me introduction about sas?

Accenture,

11 19306

1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer.

Satyam,

2 10597

is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?

3 8742

Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?

6 10072

%STPbegin;%STPEND; ERROR: No logical assign for filename _WEBOUT. WARNING: No body file. HTML output will not be created. unable to fix it.plz help

2 20377

How can we convert imr report into Impromptu web report?

3 9438

What is power prompts?Can somebody explain me.

2 6215

Can we create reports using OLTP database?How?

3 12291

How to use the tool Ontobulider

1 4098

HOW TO INSTALL BOXI

1 6300

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

Cegedim, IBM, TCS,

7 17482

Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....

TCS,

4 12061

How to connect three fact tables?

L&T, TCS,

11 22401

How to create multilingual reorts?

4 10257

Un-Answered Questions { Data Warehouse }

Describe an informatica powercenter?

1145

What is data analysis?

976

Explain the scenario which compels informatica server to reject files?

1178

what is a prompt value in report studio and variables ?

2729

How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?

1270

Define cognos report net?

987

What is a transaction control transformation?

1224

Which files are created during the session rums by informatics server?

1194

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1935

What are the facts that can compromise data integrity?

1162

explain html document?

1027

What we need to discuss with designer before starting the universe designing.

2264

Explain how many types of dimensions are available in informatica?

1117

what do u mean by bridge group? where we r using this one?

2011

What is data stream and data adaopter. Is it same are different? Explain?

1032

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