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

how do you handle ET and UV errors ?

2 10762

If the script is aborted. why it is aborted and how can you identify ?

1 4549

how can we analyze the locks ?

HP,

2142

What is the difference between lookup and sparse lookup?

1 6932

Where do i get Cognos 10 BI Online Training in Low price for the below tools. Cognos Framework Manager Cognos Report Studio Cognos Query Studio Cognos Analysis Studio Cognos Event Studio Cognos Transformer Cognos TM1 Development

11 14667

Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance

IBM,

4 8481

What is the registered Key word is sas????

TCS,

2 7447

What is difference between N and n????

Sciformix,

2 8115

When you will use nowd option in report???

Accenture,

6 22989

diff between nodup rec and ondup key???

AON, Sciformix,

3 10247

What is the difference Using & and && in the macro variables

Accenture,

5 18107

What are the advantages of setting up LOVs in the Universe?

Cap Gemini, Deloitte,

2 10246

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5658

Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

Accenture,

1 6746

Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.

1 4461

Un-Answered Questions { Data Warehouse }

I need level 2 to 5 sas using companies in india

2397

Explain what are the different versions of informatica?

1112

Clarify the aggregator change?

1039

What do you understand by a cartesian join?

1131

What are session timeout and application timeout?

1031

What is the role of sas grid administrator? : sas-grid-administration

1297

How to create diff. Types of templates?

1058

How can I schedule reports in cognos?

1023

Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

2206

Explain the difference between filter and conditin?

974

What are datastage sequences?

1132

Which is faster fastload or multiload?

1132

What you mean by drill across?

1034

is data integration and etl programming is same? : Sas-di

1090

how to merge 2 crosstabs thans

2653

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