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 pass parameters in a script?

L&T,

1 7300

whats difference between ls -ltr and ls -lrt?

L&T,

5 40702

why do we need a datawarehouse when we have databases to store data?

L&T,

1 5542

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

L&T,

4 10164

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

L&T,

2 9166

whats relation between configuration file and datasets?

L&T, Wipro,

2 11328

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 14063

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 12719

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

TCS,

2064

Which version configuration tool used in ur project?

CTS, TCS,

3266

how you will maintain version?

CTS, TCS,

3 9311

what are 3 tech challenges/ common issues you face?

TCS,

2349

have u done any performance tuning? how u ll do?

IMB, TCS,

2300

CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?

2 8017

WHAT IS SAP BO AND BO?

1 7045

Un-Answered Questions { Data Warehouse }

define sparse cube?

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2184

What are the tasks that can be performed using sq?

1096

Difference between star and snowflake schemas?

1161

How many components in your most complicated graph?

1304

I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.

2094

What are the different transaction levels available in transaction control transformation?

1212

Explain the difference between mapping parameter and mapping variable?

1045

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

3027

What is percent-to-total shortcut metric in microstrategy?

980

difference between impromptu and cognos8

2449

What a local lookup is?

1057

what are the best practices to process the large data sets in sas programming? : Sas-administrator

1030

What is transformation metric in microstrategy?

1016

What are the different methods ot loading a dimension table? A fact table etc?

1044

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