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 shift the rows to cols? eg: i have like field1 field2 field3 10 20 20 this should be displayed as field1 10 field2 20 field3 30 (without the obs col) how do this?can i use transpose or tell me suitable way to do this?

CMC,

3 8652

my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?

Dr Reddys, Oracle,

2 6767

how do i read multiple spaces in datasets? eg: vijaya raghava perumal.I tried with using & but it workss if its vijaya raghava but not for raghava perumal.how to do this?

Wipro, Xansa,

8 13543

In an existiing Framework model, how will you add a new column to the existing table?

CTS,

6 24217

How security is concerned with Reportnet? Explain its implementing steps.

iFlex,

2053

what are the joins present in reportnet?which is most widely used?

Covansys, IBM, Satyam,

4 9499

How will you migrate your reports to QA environment?

Satyam,

2 7431

There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance

1 8847

Tell me Wt main advantage of Stage varibles? Project level hints?

Hexaware,

4 14609

project Steps,hits, Project level HArd things,Solved methods?

Hexaware,

2146

What is the difference between cognos 8.2 and cognos 8.3?

5 17082

How to upgrade drivers in Cognos 8?

1 3875

how to do user inputs and command line arguments in sas?

D&B, TCS,

3062

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 16457

How to schedule the report in Cognos? And i have 2 users u1,u2. how to schedule the report for these 2 users(the 2 users will get result once for a week) but u1 get the result on every monday to his inbox,and u2 get the result on every wednesday to his inbox.

UHG,

3 11922

Un-Answered Questions { Data Warehouse }

What are the different table types that are supported by teradata?

1015

Explain the difference between mapping parameter and mapping variable?

1054

What are the applications primarily used by business analyst? : Sas-bi

1016

How to configure mapping in informatica?

1185

List out the file extensions used in abinitio?

1103

What are the main components of teradata system?

1158

What are the types of containers and how to create them?

994

Explain how to generate iqd file from framework manager?

957

What do you mean by query studio?

958

Explain access control?

1019

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2732

What are the different kinds of panes included in cognos?

1067

how tokens will generate?

2210

Explain why fact table is in normal form?

981

What is abinitio?

1184

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