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 7350

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 6815

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,

2110

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

Accenture,

7 12366

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

4 7191

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,

5453

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,

2085

without table how to come first record only in oracle?

2257

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 17378

can you use flat file for lookup table?why?

HCL,

2 8513

Un-Answered Questions { Data Warehouse }

How will the AWS redshift work?

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1977

How we can scale Reshift database?

Explain what is cost benefit analysis (cba)?

975

Explain fact degradation?

996

What are the types of containers?

1237

Explain what three things do you consider to be the most important factors for a manager?

1011

What is the difference between the public object&schema object?

1073

How to do unit testing in informatica? How to load data in informatica ?

1123

define cognos reporting tool?

Store (and count) non-fact records?

935

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

1051

how to read the variables in sas? : Sas-administrator

1023

What a datastage macro?

1063

Mention how to limit decimal places for the variable using proc means?

1120

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