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 8827

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 6887

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 13878

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

CTS,

6 24428

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

iFlex,

1 2103

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

Covansys, IBM, Satyam,

4 9689

How will you migrate your reports to QA environment?

Satyam,

2 7551

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 8923

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

Hexaware,

4 14810

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

Hexaware,

1 2194

What is the difference between cognos 8.2 and cognos 8.3?

5 17251

How to upgrade drivers in Cognos 8?

1 3939

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

D&B, TCS,

1 3130

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 16928

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 12079

Un-Answered Questions { Data Warehouse }

How do you remove duplicate records in informatica? And how many ways are there to do it?

1233

what is document design in boxi,have u participate in that

2306

EXL informatica Questions

1461

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421

Hi friends, what are the new features in abinito3.0?

2860

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

846

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1044

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2546

How would you format some text using css to be verdana and bold?

1150

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1202

What r the names of the reports that you prepared?

1030

What is dimensional table?

1164

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2104

draw informatica architecture 8.6 ?

3947

What is a rollup component? Explain about it.

1243

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