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 3898

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,

2182

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 13010

What is the difference b/w breaks and sections

IBM,

2 5757

How to get the data from the two different sourcess

IBM,

2 6414

What is self join

Blue Star, IBM,

2 6300

What is global filters and local filters

IBM,

3 8739

What is detailed Object

IBM,

1 4946

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

IBM, Oracle,

2 7232

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 6781

What is the short cut join?

Wipro,

2 5517

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 7608

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 7286

how many write modes are there in ds

IBM,

2 11466

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 19357

Un-Answered Questions { Data Warehouse }

Quickly characterize reusable change?

1127

How to delete data which is not in source table?

1347

Why cognos scenario is used?

1074

Can you define cognos powerplay?

1099

Define mapplet?

1018

How you know when to use a static cache and dynamic cache in lookup transformation?

1857

What are the different lookup cache(s)?

1123

How do you connect the desktop application to metadata server? : sas-grid-administration

1106

How do you use the do loop if you don’t know how many times you should execute the do loop?

1267

What according to you might be the future of data warehousing?

1029

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3461

Can we collect statistics on multiple columns?

1069

Can you explain data flow graph with an example?

1234

What are different types of transformations available in informatica?

997

What is the use of %include statement?

1066

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