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 8660

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 6770

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 13552

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

CTS,

6 24223

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

iFlex,

2054

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

Covansys, IBM, Satyam,

4 9505

How will you migrate your reports to QA environment?

Satyam,

2 7437

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 14612

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

Hexaware,

2146

What is the difference between cognos 8.2 and cognos 8.3?

5 17085

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 16464

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 }

Explain informatica architecture?

1013

Explain how are the dimension tables designed?

1072

how to create measures and dimensions?

1139

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1111

How to implement complex jobs in data stage?

1126

What are the components used in web tier?

1002

Can you define cube?

1040

How to convert a numeric variable to a character variable?

1219

What is meant by lookup transformation? Explain the types of lookup transformation?

969

What is the need of an ETL tool?

1120

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2470

What can you learn from the SAS log when debugging?

1402

Can we start and stop single session in concurent bstch?

958

hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?

2129

What parallelisms does Abinitio support?

1221

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