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

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

AHM,

2 6700

what is main difference between change capture and change apply stages

IBM,

4 37835

difference between server shared container and parallel shared container

CTS,

6 21279

I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?

1 4134

How do you debug macros?

Accenture,

3 10494

Can We customize the Business Object infoview in BO?

2 9346

Is it possible to develop reports without Universe access?

IBM,

7 12890

Please Send to my e-mail Interview Questions With Answers , Technical Test Questions With Answers and Code Snippets Of Business Objects - Dev , Business Objects - Reporting Analysis .

AOL,

3 5530

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

TCS,

2 9082

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

TCS,

5 14805

can we put more measure on cross tab? If so how many? How this affect the aggregation?

4 9904

How do we run stored procedure?

1 6152

..Architectural difference between cognos reportnet and cognos8?

3 7333

hi,dis is kumari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is vicky_ceti@yahoo.co.in hope u will respond as soon as possible. thank u in advance

IBM,

26 33422

daily how much amount of data send to production?

HSBC,

4 9585

Un-Answered Questions { Data Warehouse }

What is difference between user and database in teradata?

1076

What are the different common services in datastage?

1290

Explain about round-robi?

1156

What is many-to-many dimensional model in datawarehousing ?

936

Explain the informatica workflow?

1075

What is called Cognos powerplay?

1087

what happens if the info.server doesn't find the session parameter in the parameter file?

1953

What is a table alias in obiee 11g? Where and how will you create it?

1016

What is PDV?

1162

Explain the difference between holap and molap?

1058

What is the opening step in basic teradata query script?

1044

Explain etl mapping sheets?

1082

what are the special features in cognos reportnet?

1066

suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?

981

i have one file i saved in csv how can i take these file into framework manager

2086

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