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 to hide the prompts

4 10822

Can any one gve me the complete information abt Certfication of Business Objects ?

2 4975

Can any one give the example for slicing and dicing of data ?(with simple query)

Cognos,

3 20047

Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 5533

how to duplicates from expression transformation without using sorter before that

1 14963

Can anyone help to find a statement to get all the predefined formats?

Verinon Technology Solutions,

3 7732

How many repositories can we create in Informatica??

IBM, Patni,

9 33625

How to Analyise 'Join' problem and which method is the best to resolve that ?

3 7391

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 4480

What are the differences between Cognos ReportNet 1.1, Cognos 8? and enhancements in cognos 8?

IBM, iFlex, TCS,

1 9614

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

Wipro,

1 7083

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

Patni, Wipro,

7 31794

WAT IS TEXT LOAD?

Wipro,

3 9408

what is a Micro cube?

TCS,

5 13955

Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 14789

Un-Answered Questions { Data Warehouse }

Explain the different types of views used in cognos.

961

what is diff b/t sorter t/r and agg have the option sorter property...

2196

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

938

How to create prompts in report net?

1001

What is the purpose of joins in teradata and what are the available join types?

1102

update strategy transformation in informatica

1077

How many ways are there to do 'remove duplicate records in informatica'?

1028

What is authentication? How many types of authentication.

923

how to remove duplicates using proc sql?

1165

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..

2233

Name the various types of filters?

957

Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?

1700

What are non-additive facts in detail?

1014

What is the difference between s3 and redshift?

Which is the t/r that builts only single cache memory?

1203

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