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 37821

difference between server shared container and parallel shared container

CTS,

6 21262

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 4128

How do you debug macros?

Accenture,

3 10480

Can We customize the Business Object infoview in BO?

2 9337

Is it possible to develop reports without Universe access?

IBM,

7 12866

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 5518

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 9069

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 14797

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 6139

..Architectural difference between cognos reportnet and cognos8?

3 7315

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 33386

daily how much amount of data send to production?

HSBC,

4 9569

Un-Answered Questions { Data Warehouse }

what are the errors,warnings in datastage

2698

What is a pre-defined event and user-defined event?

1037

What is dimension modeling?

1087

how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

1031

How to deploy from one server to another server?

2490

what do you mean by passthrough functions?

969

in general which algorithms for used?

2026

What do you understand by a term domain?

1124

What are the different common services in datastage?

1284

If you want to use a same piece of code in different jobs, how will you achieve this?

1276

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4188

What subtotaling features does microstrategy desktop contain?

986

What are the databases that informatica can connect to windows?

1049

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1664

What is transformation?

1099

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