Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

TCS,

2 7478

I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos

IBM,

1 6904

Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

IBM,

2153

in data set200 observation how to take 110,150,170 using sql procedure?

Accenture,

7 12599

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 7341

hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

SAS,

5508

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

IBM,

2141

without table how to come first record only in oracle?

2306

Suppose there is a SAS dataset with following values - Parent Child A B B C D E F G G H H I and so on….. This goes onto 1000s of observations/rows. Now how do we identify from this dataset Grandparents and Grandchildrens ?

American Express, Barclays,

5 17586

can you use flat file for lookup table?why?

HCL,

2 8619

Un-Answered Questions { Data Warehouse }

what is the difference between infile and input? : Sas-administrator

1208

Can you define fan trap?

1317

What are the types of caches in lookup? Explain them.

1016

How to schedule the report in b.o?

1104

What is difference between webi and infoview?

1336

Explain how many types of dimensions are available in informatica?

1176

8. How much supervision have you typically received in your previous job?

2317

Define Merge?

1374

Define query studio?

1048

What you mean by drill across and what is the difference between drill through, drill across?

1088

explain about citrix scheduling tool in datastage

2512

why a stop statement is needed for the point= option on a set statement?

1139

Where the applications and where

973

What is called Cognos powerplay?

1148

explain about balanced dimension,

1042

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