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 3901

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,

2188

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 13020

What is the difference b/w breaks and sections

IBM,

2 5769

How to get the data from the two different sourcess

IBM,

2 6428

What is self join

Blue Star, IBM,

2 6304

What is global filters and local filters

IBM,

3 8749

What is detailed Object

IBM,

1 4948

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

IBM, Oracle,

2 7243

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 6792

What is the short cut join?

Wipro,

2 5527

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 7619

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 7297

how many write modes are there in ds

IBM,

2 11472

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 19371

Un-Answered Questions { Data Warehouse }

How many types of joins are there in teradata?

981

What is status code in informatica?

1026

How do you convert single row from source into three rows into target?

1172

Explain what is the difference between business requirement document and use case document.

1036

I need a good brd and uc template?

1097

What is the scenario which compels informatica server to reject files?

1083

How can you communicate with web server (apache or iis) from coldfusion?

1126

How to publish a package by running Java Script?

2093

Which command is used to save logs in the external file?

1111

How to go to the older version for a mapping?

1113

Design time, run time. If you don't create parameter what will happen

1843

Describe a time when you were really stuck on a problem and how you solved it?

2645

Explain the hierarchies level data warehousing.

895

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

2136

How can you export a component’s internal parameters ?

2410

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