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

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 7849

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

IBM,

2136

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

IBM,

1 4303

Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated

1 5521

what is mean by complex business rule ?

Cap Gemini,

2177

Does anyone got Latest TERADATA V12 Certification Dumps for the below? TE0-121 , TE0-122 , TE0-123 , TE0-124 , TE0-125 , TE0-126 TE0-127 , TE0-12Q

45 51318

hi my name is siraj i want to know cognos queriy language

2282

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

Wipro,

1 3690

why union is active transformation?

IBM,

4 8213

how to use incremental load?

TCS,

2 8082

My source table having some records ,i want load 1st record and last record into one target?

iGate,

3 9839

what is incremental aggregation ,with example?

2 9215

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

DELL,

8 13422

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2091

How many ways we test the universe & Report?

2 6124

Un-Answered Questions { Data Warehouse }

List out some key concept of SAS

1146

What is sequence generator transformation in informatica?

1090

Compare cold fusion with other programming languages?

1016

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2079

Define Dynamic push down optmization?

2309

What are the different methods of loading dimension tables?

1000

5. Which type of report you build more, list, crosstab or chart and why?

2025

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2399

How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

1944

How to load the time dimension?

1027

how does sas handle missing values in sort order? : Sas programming

930

What is fact extension?

1143

Whether dimension table can have numeric value?

1167

What happens if the owner of an object does not exist in the destination project?

927

What is the difference between partitioning with key / hash and round robin?

1397

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