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 6270

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 13088

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 13185

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

1 6548

What does error:1 mean?

Accenture,

8 13494

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

Accenture, HSBC,

14 59609

What report output formats can you generate using SAS?

Accenture,

3 9302

What does a PROC TRANSPOSE do?

Accenture,

8 19666

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 18388

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 12120

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 3692

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 5946

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 10261

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

Accenture, Aegis,

2 10251

5.what is slowly changing dimension ?

IBM,

2 10971

Un-Answered Questions { Data Warehouse }

What is a sorter transformation?

1167

Tell e how how dealt with..

2269

What are the steps to import the two data sources in framework manager?

1096

what is the meaning of upgradation of Repository?

3808

Explain parsing engine in teradata?

1150

Explain security filter?

1132

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3646

What is the different type of jobs in datastage?

1037

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1031

In SAS explain which statement does not perform automatic conversions in comparisons?

1379

What are the different versions of informatica?

1349

What do you know about partition and also tell us about partition components in abinitio?

1119

how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?

9354

Can we create a Integration service without a Repository service and vice versa?

1260

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?

1102

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