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 7853

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 4306

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 5522

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 51366

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

2285

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

Wipro,

1 3691

why union is active transformation?

IBM,

4 8216

how to use incremental load?

TCS,

2 8086

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 9219

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

DELL,

8 13434

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

2093

How many ways we test the universe & Report?

2 6127

Un-Answered Questions { Data Warehouse }

Explain three-tier connection?

970

what is requery in cognos?

2497

What is the status code in stored procedure transformation?

1198

What is the difference between operational data stage (ods) and data warehouse?

1257

Why and when do you use proc sql?

1256

What is the need for an etl tool?

1081

what is the function of catx syntax? : Sas-administrator

1118

What is the function of parser component in teradata?

1101

What is the benefit of session partitioning?

1128

What is level based metrics.how will you create it?

887

Did you used proc test? when?

2051

List out the file extensions used in abinitio?

1103

What actually a project contains?

1108

How to create model and how to test model?

1041

Explain what is a cube in data warehousing concept?

997

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