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 10743

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

1 4536

how can we analyze the locks ?

HP,

2132

What is the difference between lookup and sparse lookup?

1 6913

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 14606

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 8451

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

TCS,

2 7417

What is difference between N and n????

Sciformix,

2 8086

When you will use nowd option in report???

Accenture,

6 22954

diff between nodup rec and ondup key???

AON, Sciformix,

3 10228

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

Accenture,

5 18063

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

Cap Gemini, Deloitte,

2 10219

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?

5648

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 6731

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 4439

Un-Answered Questions { Data Warehouse }

Explain how many universes can be created in a project?

1061

what are the Methods For Creating Reusable Transformations?

1172

what is data access? : Sas-di

1144

what is operational data and operational system? : Sas-di

1115

Explain attribute?

975

Enlist the syntax rules followed in sas statements.

1086

How to design file watch jobs?

972

How to do the error handling of if ur source is flatfiles?

1968

What is stored procedure in teradata?

1030

what is the difference between == and eq in UNIX shell scripting?

1500

how many users can open or connect to one of the tm1 web application concurrently?

AWS Redshift is basically works on nodes and cluster and which of following option Redshift is based on?

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2375

What are the various types of transformation?

1179

Give me any example of semi and non additive measures?

967

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