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 7803

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

1 4221

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 4822

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

2136

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 15714

what is the difference between stop and abort

2 5627

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 3753

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 }

What is the roundrobin collector?

1099

Can you explain surrogate key?

1040

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1081

Mention some ways for improving performance of a graph?

1087

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1203

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1109

What is the need of etl tools?

1120

What are data-driven sessions?

1207

What is load manager?

1045

how to run turbo integrator process from command line?

Explain what are non-additive facts in detail?

1035

whom do you report?

1930

How we can covert server job to a parallel job?

1147

Explain the key challenges that you face while performing etl testing.

1009

have u done any performance tuning? how u ll do?

2299

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