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 9474

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

Accenture,

11 19303

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 10594

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

3 8739

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 10067

%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 20375

How can we convert imr report into Impromptu web report?

3 9434

What is power prompts?Can somebody explain me.

2 6211

Can we create reports using OLTP database?How?

3 12285

How to use the tool Ontobulider

1 4097

HOW TO INSTALL BOXI

1 6297

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 17477

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

TCS,

4 12057

How to connect three fact tables?

L&T, TCS,

11 22391

How to create multilingual reorts?

4 10252

Un-Answered Questions { Data Warehouse }

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2020

This entry was posted in General. Bookmark the permalink. Post a comment or leave

4593

What are the different types of transformation available in informatica.

1117

What is pmcmd command?

1137

What is microstrategy?

985

what is treatment emergent events and treatment emregent adverse event

2414

What is grain of fact?

995

What is Cognos script editor?

4247

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2136

How do y read Sequential file from job control?

15988

Explain conformed fact?

980

What is union transformation in informatica?

1154

What is called a slice?

1040

What do you mean by fastexport in teradata?

1018

How do you delete duplicate observations in sas?

1085

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