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

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

iFlex,

3 10653

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

iFlex,

2 5553

Difference between ODS and Staging

HeadStrong, TCS,

4 40607

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow

Wipro,

4 12226

how DTM buffer size and buffer block size are related

Wipro,

3 31423

how much memory (size) occupied by a session at runtime

Wipro,

4 13625

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

Wipro,

3 11591

how can we improve performance of the reports?

6 10873

What is the Computation error? how to solv it?

1 12698

Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?

2 6589

what is picture format? give any one example?

Parexel,

3 11408

what is the main difference between rename and label? (don't say that they both perform the same function).

Parexel,

11 24964

how to display duplicated observations in a data using base sas.

HCL, TCS,

13 31142

what is TAB delimiter? explain about it? what will you do to get TAB delimiter?

Cap Gemini,

3 14577

wat has been most common programming mistake?

3 6664

Un-Answered Questions { Data Warehouse }

What are snapshots?

993

What are default access rights in teradata?

1148

What do you mean by ttu in teradata?

1056

Can you define pivot?

1130

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 business intelligence? : Sas-bi

1078

What is the difference between input and infile statement?

1185

Briefly explain the aggregator transformation?

1025

How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1195

Explain the various types of filters available.

1016

Can Bo generates the Report from the cubical data Explain?

2049

Separate from a database, an information bazaar, and an information stockroom?

1097

What are the advantages of teradata?

1031

Define catalog in cognos and write its various types?

1195

What is perform recovery?

1126

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