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 can u load the data in time dimension?

3 12513

what is the diff b/w target load plan and cbl?

CTS, iGate,

3 27708

what is the use of macros&folders&herarchies in frameworkmanger?

1 4339

How to give a securites in object level&datalevel&pakege lavel in frame work manager?

1 3135

Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?

TCS,

5 14593

How do you test the performance of a report?

TCS,

3 9255

what is crystal reports?how to migrate them?

IBM,

2 6543

what are the roles & responsibilities of microstrategy developer?

Infosys,

13 42765

What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?

2 16852

What is meant by ZABO and FC(full-client)?

2 12486

if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?

CTS, TCS,

3 10872

in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

1 1968

Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com

Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,

320 295405

wt is meant by repartioning in howmany ways it can be done.

2 9992

what is the difference between rollup aggregation and aggregation ?

1 5565

Un-Answered Questions { Data Warehouse }

What r the names of the reports that you prepared?

1028

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1238

Explain scd type 3 through mapping.

1070

How to add default rules in transformer?

1284

what are the data modeling tools you have used?(polaris)

2057

Hi, If anyone has base SAS certification dumps, please share.

1936

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3441

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1199

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1041

How to create the source and target database connections in server manager?

1144

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1667

How do you remove duplicate records in informatica? And how many ways are there to do it?

1231

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

2206

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

845

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2491

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