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

Why we take so long time to display date prompt before displaying a report? How can we reduce the time?

2 6258

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

iFlex,

5 13055

1.tyes of security in cognos?.how to use rank function? 2.what is content store? 3.what is content manager? 4.how 2 use rank function?

3 13171

wt is tupple , Embed function ? wt is regular dimension ?

1 6539

What does error:1 mean?

Accenture,

8 13458

What is the difference between a PROC step and a DATA step?

Accenture, HSBC,

14 59547

What report output formats can you generate using SAS?

Accenture,

3 9288

What does a PROC TRANSPOSE do?

Accenture,

8 19640

hi guys ...i have one query... data abc; input s w k g o t a m; cards; 1 2 3 4 5 6 7 8 2 3 4 5 6 7 8 9 ; run; i want the output to be the sorted order(only variables).observations should not be changed..

14 18305

How can the following be achieved in 1 single Informatica Mapping. * If the Header table record has error value(NULL) then those records and the corresponding child records in the SUBHEAD and DETAIL tables should also not be loaded into the target(TARGET1,TARGET 2 or TARGET3). * If the HEADER table record is valid, but the SUBHEAD or DETAIL table record has an error value (NULL) then the no data should be loaded into the target TARGET1,TARGET 2 or TARGET3. * If the HEADER table record is valid and the SUBHEAD or DETAIL table record also has valid records only then the data should be loaded into the target TARGET1,TARGET 2 and TARGET3. =================================================== HEADER COL1 COL2 COL3 COL5 COL6 1 ABC NULL NULL CITY1 2 XYZ 456 TUBE CITY2 3 GTD 564 PIN CITY3 SUBHEAD COL1 COL2 COL3 COL5 COL6 1 1001 VAL3 748 543 1 1002 VAL4 33 22 1 1003 VAL6 23 11 2 2001 AAP1 334 443 2 2002 AAP2 44 22 3 3001 RAD2 NULL 33 3 3002 RAD3 NULL 234 3 3003 RAD4 83 31 DETAIL COL1 COL2 COL3 COL5 COL6 1 D001 TXX2 748 543 1 D002 TXX3 33 22 1 D003 TXX4 23 11 2 D001 PXX2 56 224 2 D002 PXX3 666 332 ======================================================== TARGET1 2 XYZ 456 TUBE CITY2 TARGET2 2 2001 AAP1 334 443 2 2002 AAP2 44 22 TARGET3 2 D001 PXX2 56 224 2 D002 PXX3 666 332

IBM, Mphasis,

3 12110

Hi I am starter in BOXIR2.CAn anyone plz tell me the user identification details to be entered at the time of login to designer/deski

1 3688

Can we install cognos 8 on windwos xp sp3.......(and i like to use data base as sql server 2000.....is it preferable?)......... pls let meknow... thaks in advance...

1 5941

1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ?

BNP Paribas,

1 10257

4.what is aggregate awareness ? how do we use ? where do we use ?

Accenture, Aegis,

2 10244

5.what is slowly changing dimension ?

IBM,

2 10961

Un-Answered Questions { Data Warehouse }

Is multi insert ansi standard?

2257

What is the basic structure of the SAS base program?

1413

How to compare two dmls in abinitio

1885

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2606

Enlist the differences between database and data warehouse.

1169

Do you know what a local lookup is?

1270

How does microstrategy object manager integrate with the microstrategy product suite security model?

1006

What are the automatic variables for macro? : sas-macro

1335

Can anyone give me an example of realtime start script in the graph?

1227

Explain teradata utilities. What is multiload, fast load, tpump?

1049

What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?

1019

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2207

How to find duplicates in a table?

1282

Explain adhoc reports?

981

What are pass-through functions and why they are so called? Give some examples.

1110

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