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

Hi Buddies... i want to appear for cognos BI-Author certification. can anyone of you send me cognos latest dump. please help me.. cognoslalitha@gmail.com

4 5606

what is the difference between list sequel and cross tab sequel?

2 6433

my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it

1 2947

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

TCS,

2 18351

Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

TCS,

2220

hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

2128

my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 11628

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

KPIT,

2 7003

How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?

1 5648

I need level 2 to 5 sas using companies in india

2382

What is meant by MATCHTAG in multiload utility?

Satyam,

2 8894

Hash collision?

Satyam,

3 10627

what is meant by Hot amp?

IBM, Satyam,

2 13790

i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me

Satyam,

8 11216

I want to learn Microstrategy Tool...Can you help me to find best coaching center for Microstategy..please send details to maheswari.umaece@gmail.com Thanks and Regards, Uma

4 11735

Un-Answered Questions { Data Warehouse }

What is metadata in context of a datawarehouse and how it is important?

1048

How to create an external dataset with sas code?

1158

Explain the informatica workflow?

1070

Why do we need informatica?

992

What is surrogate key? Where we use it?

997

What is MPP. Is Redshift support MPP?

What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2906

What is the difference between datawarehousing and businessintelligence?

1100

What do you mean by fastexport in teradata?

1000

What is joiner transformation in informatica?

1045

How many types of stage?

1180

What is the difference between a cascading report and drill through report?

1072

How do you see a ddl for an existing table?

1018

Explain the term 'tables' related to relational database management system?

1048

what has been your most common programming mistake? : Sas programming

1108

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