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

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

TCS,

2 8733

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

TCS,

7 10405

differences between service based and product based?

Satyam,

2060

What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?

Patni,

2 7831

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

Satyam,

3 7373

What is the architecture of ur project? can u explain it? PLz

Patni,

1 3728

Can we insert ,update ,delete in target tables with one update strategy tran.?

Zensar,

2 11560

why we use materialized view over view?

Zensar,

1 5406

can session assigned multiple mappings or not?

Zensar,

2 8262

we have to use order by,where,having we to implement sql query

Satyam,

1 5350

what is the default character set in teradata,,?

IBM, TCS,

2 11398

What is SQL Assistence?please eample

IBM,

4 8503

Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends

1 4497

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

Cognizant,

1 3164

in performance wise union is past,union all is past

2 5543

Un-Answered Questions { Data Warehouse }

What is defined as Cognos Impromptu?

1130

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

995

What is bi?

1185

Define metrics studio?

1082

What are the scrubbing procedures in sas?

1063

Informatica settings are available in which file?

1049

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

2004

when will use SQL override in a lookup transformation?

2345

How to add default rules in transformer?

1271

What are the features of base sas system?

1116

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2174

What are the advantages of cold fusion?

1010

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.

2342

What are the data types does SAS contain?

1172

What are Aggregate tables?

1229

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