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

What is fact extension?

1208

Explain the Roles in mstr?

1034

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

1006

What is dynamic aggregation in microstrategy?

1027

What is scanmd and md doctor?

1120

Can the administrator easily maintain and manage microstrategy intelligence server?

1072

What is derived metric?

1035

What is a security filter in microstrategy?

1072

What are logical views used for in microstrategy?

1021

What are public objects?

1100

What is the difference in the way microstrategy handles custom group and consolidations?

1043

How conflicts occur and what are the ways to resolve them?

1011

What are configuration objects?

1105

What are the enhanced features in teradata v2r5 and v2r6?

1189

Explain Teradata performance tuning and optimization?

1224

Un-Answered Questions { Data Warehouse }

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2244

Can you define confirmed dimension?

1144

define galaxy repository in informatica

2290

Can microstrategy intelligence server scale easily and cost effectively based on my growing needs?

1099

What is data cleaning?

1004

What information is shared by the application across microstrategy web nodes?

1098

What Is The Difference Between Oltp And Olap?

1173

Plz can any one say me how to get the informatica certification materials and dumps

2104

List the logical and conditional operators that are used with teradata along with their meanings?

1046

What are the difference between the sas data step and sas procs?

1256

Explain about enterprise scalability and roi of data integration suite?

935

How do you improve the performance of the Cognos Analytics report

1103

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.

2340

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2250

What do you understand by the term 'model durability'?

1075

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