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

What SAS statements would you code to read an external raw data file to a DATA step?

Accenture,

6 13329

How do you read in the variables that you need?

Accenture,

9 25188

Are you familiar with special input delimiters? How are they used?

Accenture,

4 16642

If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?

Accenture,

3 13936

What is the difference between an informat and a format? Name three informats or formats.

Accenture, IBM,

13 31728

Name and describe three SAS functions that you have used, if any?

Accenture,

4 16927

How would you code the criteria to restrict the output to be produced?

Accenture,

6 14081

What is the purpose of the trailing @? The @@? How would you use them?

Accenture,

10 48988

Under what circumstances would you code a SELECT construct instead of IF statements?

Accenture,

7 15673

What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?

Accenture,

2 10418

If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?

Accenture,

7 24516

If you’re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?

Accenture,

8 21398

What is the one statement to set the criteria of data that can be coded in any step?

Accenture,

4 11299

Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.

Accenture,

2 9875

How would you include common or reuse code to be processed along with your statements?

Accenture,

3 8768

Un-Answered Questions { Data Warehouse }

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3441

Write the unconnected lookup syntax and how to return more than one column.

1174

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2169

What is node? How many nodes and amps used in your previous project?

1173

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1962

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2299

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

846

explain in detail about type 3?

1083

What is a rollup component? Explain about it.

1241

How to add default rules in transformer?

1284

What sort of existing documents should business analysts refer to when starting on a new project?

1078

Write the unconnected lookup syntax?

1146

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2207

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2766

How would you format some text using css to be verdana and bold?

1146

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