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 can u load the data in time dimension?

3 12312

what is the diff b/w target load plan and cbl?

CTS, iGate,

3 27516

what is the use of macros&folders&herarchies in frameworkmanger?

1 4236

How to give a securites in object level&datalevel&pakege lavel in frame work manager?

1 3041

Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?

TCS,

5 14292

How do you test the performance of a report?

TCS,

3 9080

what is crystal reports?how to migrate them?

IBM,

2 6310

what are the roles & responsibilities of microstrategy developer?

Infosys,

13 42143

What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?

2 16673

What is meant by ZABO and FC(full-client)?

2 12343

if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?

CTS, TCS,

3 10657

in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

1909

Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com

Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,

320 283715

wt is meant by repartioning in howmany ways it can be done.

2 9795

what is the difference between rollup aggregation and aggregation ?

1 5469

Un-Answered Questions { Data Warehouse }

How we can call macros with in data step? : sas-macro

1125

What is difference between page break and section report? What is main advantage datawarehousing over oracle?

1014

differentiate between two-tier, three-tier and four-tier connections.

986

how to remove duplicates using proc sql?

1148

what is the use of materialized view?

1570

Can reports be executed in off-peak periods?

997

Explain batch processing in ab initio?

1451

What is AWS Redshift is used for ?

write a query to retrieve the latest records from the table sorted by version(scd)

1068

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2061

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1538

Explain what is data validation strategies for data mart validation after loading process?

1029

what is study design in while working with SAS? what are screening variables in SAS?

2242

Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

960

What are slice and dice?

925

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