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

can we use detail in generation of reports? if customer id is a dimension in a report, what will happen if we define it as a detail?

3 6959

Whatis the difference between View and Materialized View ?

Satyam, Syntel,

11 56521

wHAI IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB REPORT?

7 31921

Hello, I have PROC SQLs results group by 3 fields and I use SUM and COUNT functions in SQL. The problem is when I try to display my result with PROC TABULATE. I am getting very big numbers. I believe I make a mistake some where in Tabulate. Here is my Proc Tabulate. PROC TABULATE DATA=OUT04_05 FORMAT=12.; CLASS YR CENTRE VISA / PRELOADFMT EXCLUSIVE; VAR NEWUSER FRAUD TRANSFER AUTUSER REISSUE; TABLE CENTRE ALL, (YR ALL)*VISA, (NEWUSER*F=COMMA12. AUTUSER*F=COMMA12. FRAUD*F=COMMA12. TRANSFER*F=COMMA12. REISSUE*F=COMMA12.) / MISSTEXT={LABEL='0'} PRINTMISS RTS=20; FORMAT VISA VISAFMT.; KEYLABEL SUM = ' ' ALL = 'TOTAL'; LABEL YR = 'DATE YEAR' NEWUSER = 'TOTAL NEW ACCT' TRANSFER = 'TOTAL TRANSFER' FRAUD = 'TOTAL FRAUD TRANSFER' AUTUSER = 'TOTAL AUTH USERS' REISSUE = 'TOTAL REISSUE'; When I code it like : NEWUSER*N*F=COMMA12. AUTUSER*N*F=COMMA12. I get same amount numbers but to find a NEWUSER I use COUNT(*) and to find AUTUSER I use SUM(xxxx) function so both result shouldn’t be the same my problem is in this point. Could you tell me where the problem in code is. How can I display my result? TX.

2282

What is slowely changing dimensions?why we are used SCD?

2 7224

What is difference between drill through and drill down?

IBM,

5 18527

Without using any transformations how u can load the data into target?

IBM,

15 24844

what is casual dimension?

IBM,

6 19154

WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI

TCS,

5 13537

how we can call macros with in data step?

Allianz, ManPower,

17 27306

What is the use of Surrogate key in BO?

IBM,

8 18363

What is the use of Surrogate Key in BO?

CTS, IBM,

2 9695

What is casual dimension?

4 17007

What is a diff between joiner and lookup transformation

CTS, Satyam, TCS, UHG,

16 96021

How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.

Cognizant, WinAlliance,

1 8795

Un-Answered Questions { Data Warehouse }

Have you used the rollup component? Describe how?

1132

What is data analysis? Where it will be used?

995

Differentiate between a repository server and a powerhouse?

1134

Explain what is the main advantage of impromptu over cognos reportnet?

1060

What are the 5 phases in a multiload utility?

1052

Explain fact constellation schema?

1053

Explain Quality stage?

1168

What are dimensions?

1078

What parallelisms does Abinitio support?

1220

Why redshift Distribution key is used?

Explain vldb?

1048

What are the steps involved after the disk manager passes the request?

1133

What is fact? What are the types of facts?

1132

Which function is used to count the number of intervals between two sas dates?

1142

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

973

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