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

in oracle write query yourname+1 from dual

5 7804

Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?

1 4222

Can some one say abt "ALL" in prompt .. How to get the word "ALL" in the prompt along with the list of values? Plz give me the steps?

Accenture, Wipro,

7 12667

what is proc Index? and what is proc document?

Mind Tree,

2723

what is the prob plot in clinical domain

TCS,

1 4823

how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?

TCS, Thomson Reuters,

3 9207

what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

2019

can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

2137

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

Cap Gemini, TCS, Wipro,

1 15715

what is the difference between stop and abort

2 5628

How to get max salary of an organization using data stage stages........... can any body help me plz.......

Cap Gemini,

7 30424

tell me about your project functionality

2341

tell me 7.x and 8.x diferrencess(but not transformations)

1 3754

tell me the rules and responsblites in our project(my project is development)

1933

tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 3691

Un-Answered Questions { Data Warehouse }

it will become easy if uuu provide website linkssss and list of consultanciessssss

1979

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

920

How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1674

is cognos 7 is better than cognos 8

2165

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2277

What are the parameters of scan function?

1176

Write the advantages of partitioning a session?

1282

What is oltp?

977

What is defined as catalog and types of catalogs in Cognos?

1136

How to reverse the string using unix?

3509

Explain datastage architecture?

1402

Explain the meaning of Amp?

1152

Can you define snapshot?

923

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1154

what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

2019

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