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 10861

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

1 4636

how can we analyze the locks ?

HP,

2198

What is the difference between lookup and sparse lookup?

1 7018

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 15051

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 8655

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

TCS,

2 7540

What is difference between N and n????

Sciformix,

2 8209

When you will use nowd option in report???

Accenture,

6 23172

diff between nodup rec and ondup key???

AON, Sciformix,

3 10356

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

Accenture,

5 18286

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

Cap Gemini, Deloitte,

2 10360

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?

5708

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 6809

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 4552

Un-Answered Questions { Data Warehouse }

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2201

Suggest a good author for hyperion in data warehousing?

1029

Have you used macros? For what purpose you have used? : sas-macro

1098

explain the methodology of Data Warehousing?(Polaries)

2383

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2168

What are the types of studio present in Cognos?

1085

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10539

What’s the use of redshift?

Explain transaction control transformation in informatica

1316

What is data movement mode in Informatica and difference between them?

1190

What is metric store database?

1048

What is the scenario which compels informatica server to reject files?

1128

What are the newly developed features of Teradata?

1094

Explain what is real time data-warehousing?

1189

in sap bi we have wad, then why we go for sap bo

3439

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