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 6690

what is main difference between change capture and change apply stages

IBM,

4 37823

difference between server shared container and parallel shared container

CTS,

6 21264

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 4129

How do you debug macros?

Accenture,

3 10483

Can We customize the Business Object infoview in BO?

2 9340

Is it possible to develop reports without Universe access?

IBM,

7 12869

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 5521

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 9071

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 14798

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

4 9887

How do we run stored procedure?

1 6140

..Architectural difference between cognos reportnet and cognos8?

3 7316

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 33390

daily how much amount of data send to production?

HSBC,

4 9571

Un-Answered Questions { Data Warehouse }

Have you ever encountered an error called “depth not equal”?

1163

What is the difference between an operational datastage and a data warehouse?

1154

difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

2835

Can you suggest us materials for sdtm mapping?

4448

How does hashing happens in teradata?

1091

What are the advantages of cold fusion?

952

what is the difference between querystudio in reportnet and cognos8

2137

What are Dimensional table?

1055

What is an enterprise?

1042

what is the complex transformation you used in informatica

2587

What sort of existing documents should business analysts refer to when starting on a new project?

1010

What is the size of the cube?

975

Can I deploy a single bi application in multiple languages?

977

what are _numeric_ and _character_ and what do they do? : Sas programming

1156

How to load a Dimension ? and how to load a fact table?

1418

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