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 is sas data set?

1062

How will you generate test data with no input data?

1117

What is the difference between input and infile statement?

1119

What is the difference between reading data from an external file and reading data from an existing data set?

1127

Describe the ways in which you can create a macro variable?

1040

Mention the category in which sas informats are placed?

982

How substr function works in sas?

1161

What is the difference between informat and format statement?

1 1572

How do dates work in sas?

1080

What is the difference between the proc sql and data step?

1113

What is the good sas programming practices for processing large data sets?

1065

What is the difference between where and if statement?

1073

What are the different types of sas functions?

1195

Mention common programming errors committed in sas ?

1069

What is by-group processing?

953

Un-Answered Questions { Data Warehouse }

For what purpose would you use the RETAIN statement?

1473

hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

2066

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2132

What is MPP in Redshift ?

Why cognos scenario is used?

1012

What are the different types of parallelism used in abinitio?

1050

What are the issues you have faced in your project? How did you overcome those issues?

2298

r u done any partitions in ur project?

1760

What happens in a conflict? How do you handle that?

997

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1954

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1277

Explain the structure of cold fusion?

995

What do you understand by the term 'aggregate advisor?'

909

how much memory space occupied real time project (roughly)?

2185

what are 3 tech challenges/ common issues you face?

2289

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