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 a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 3974

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

IBM,

2229

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

Teradata,

6 13197

What is the difference b/w breaks and sections

IBM,

2 5862

How to get the data from the two different sourcess

IBM,

2 6525

What is self join

Blue Star, IBM,

2 6420

What is global filters and local filters

IBM,

3 8890

What is detailed Object

IBM,

1 5013

Can we link the Universes from two different sourcess?Explain?

IBM, Oracle,

2 7333

I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process

Wipro,

2 6872

What is the short cut join?

Wipro,

2 5654

Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?

Wipro,

2 7726

1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?

3 7391

how many write modes are there in ds

IBM,

2 11569

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

HCL, Schneider,

6 19572

Un-Answered Questions { Data Warehouse }

What do the put and input function do?

1118

What are the special input delimiters used in SAS?

1246

name the scheduler for scheduling job and explain the scheduler? : Sas-di

1105

What is teradata and why it is used?

1187

Enlist few areas or real-time situations where informatica is required.

1146

how to add a new records into source?

2060

What are the features of ab initio?

1161

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1219

What is the difference between ‘macro’ and ‘prompt?

1150

Is it possible to apply themes to microstrategy web? How?

1004

What is main difference mapplets and mapping?

1279

Code check-in and check-out commands in AbInitio

4382

What is surrogate key? Where we use it? Explain with examples.

1082

tell me two or three issues from client side and how to solve those issues?

2222

What do you know about symput and symget?

1322

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