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

I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?

IBM,

2 8445

What is Additive function?

IBM,

2085

Is it possible to create drill through access to other report from PDF report?

IBM,

1 3516

What is Online View?

IBM,

2011

What is Star schema group?

IBM,

1 9745

How to move reports one server to another server?

Wipro,

2 9537

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 7454

How union transformation is active ?

Puma,

2 6032

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

Puma,

7 10833

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

Cap Gemini, Puma, Wipro,

3 10762

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

Puma,

5 9158

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

Puma,

2134

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

Puma,

2251

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

Puma,

2 6958

What is flashback table ? Advance thanks

Puma,

2001

Un-Answered Questions { Data Warehouse }

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1202

What is the difference between dml expression and xfr expression?

1160

Is redshift using primary keys for key-value storage?

What is the difference between teradata and oracle?

1071

How is possible this scenario using in type-in prompt.?

1103

Explain what are the various methods of getting incremental records or delta records from the source systems?

1032

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2996

What do you understand by local lookup?

1217

What are the types of SCD?

1290

Do you find any difficulty while working with flat files as source and target?

1154

According to his methodology what all you need before you build a datawarehouse

1806

define tm1 package connector?

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1159

What is the difference between reading data from an external file and reading data from an existing data set?

1232

Different phases of multiload?

1068

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