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 index awareness in universe?

1037

What is data stream and data adaopter?

1097

What are the advantages of cold fusion?

956

How can you set the session management?

1131

I need to set predefined condition. How I do this?

1022

What are steps we have to follow in designing the userfriendly universe?

980

Difference between cold fusion mx 6 and cold fusion mx 7?

844

How can you set the client management?

1024

Explain in detail abt measure objects? And what is the use of it? How to create it?

1019

In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?

1050

What is mean by aggregate aware?

1098

How to create context?

1015

What are universe requirements?

1056

How to performance tune reports?

1179

What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

906

Un-Answered Questions { Data Warehouse }

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

2224

How is character variable converted into numeric variable and vice versa?

1183

Why double trailing @@ is used in input statement?

1233

What is the difference between input and infile statement?

1179

Briefly state different between data ware house & data mart?

1056

What is difference macros and prompts?

2316

What does reusable transformation mean?

1142

What is a real-time data warehouse?

1004

Describe the grant/revoke ddl facility and how it is implemented?

1154

Implementation methodology

1723

What is the difference between Datawarehouse and OLAP?

930

Code the tables statement to produce a multi-level frequency?

1019

how can we direct the sql generated to use a specifc table?

935

What will be the skew for, input file->partition by key-> partition by round robin->output file

970

Difference between sequential file and data set?

1210

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