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 deploy from one server to another server?

2436

How do we convert from Numeric to be Words?

2947

Sales person are there in one company How to do Bursting on this particular requirement?

2127

How to Reset Pagenumbers in one report.

2605

Explain about Parametermap?

1 4683

How do you Parametermap variables in Quiries?

TCS,

2212

How the Bursting happens in same report and how to Print the bursting Report?

IBM,

1815

Explain about scorecarding?

2019

What are the Macros?

3 6524

Tell me about Dnamic and Static Dashboards?

2278

How to create Events?

1 7693

what are ERP systems?

1 4147

what is deeup in unique only?

IBM,

5 17968

In MFS i developer developed 2-way, but supporters r supporting 4-way on same records how is possible?

IBM,

4 13565

the inputs are 10,20,30,40,50 but the output was comes 0 records,the graph was failed what is bad situation?

EDS,

5 12053

Un-Answered Questions { Data Warehouse }

Explain the architecture of amazon redshift?

What is the use of dimensional modeling in data warehousing?

923

What is the difference between union and union all in teradata?

1061

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4046

What is the format of informatica objects in a repository?

980

What is aggregate table and aggregate fact table ... Any examples of both?

1007

Describe a time when you were really stuck on a problem and how you solved it?

2491

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

929

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2809

How many sessions of MAX is PE capable of handling at a particular time?

1036

How many components in your most complicated graph?

1235

Explain object variable error?

931

What are all the components of Report Studio?

1049

any difficulitis have you phase while creating bo reports and how did u solve it

3394

what is slowly changing dimension? : Sas-di

1072

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