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 5814

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

2 6556

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 3024

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

TCS,

2 18498

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,

2284

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

2209

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 11931

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 7181

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 5735

I need level 2 to 5 sas using companies in india

2450

What is meant by MATCHTAG in multiload utility?

Satyam,

2 9011

Hash collision?

Satyam,

3 10788

what is meant by Hot amp?

IBM, Satyam,

2 13954

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 11458

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 11934

Un-Answered Questions { Data Warehouse }

What is the use of powerhouse?

1152

How will change port of obiee answers?

912

Explain what are the various transformation available?

1085

define cognos connection?

What are all the types of hierarchies?

1190

What is domain in terms of informatica?

1074

What are the different types of important services used in cognos?

1068

We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

1487

What is a transaction control transformation?

1270

How does microstrategy object manager determine if two projects are related?

1114

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

1121

describe the Steps to confiure a Qlogic switch

2442

What is the difference between a data mart and a data warehouse?

1106

What is meant by a Virtual Disk?

1217

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3227

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