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 7802

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 12662

what is proc Index? and what is proc document?

Mind Tree,

2723

what is the prob plot in clinical domain

TCS,

1 4818

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 9204

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 5626

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

Cap Gemini,

7 30422

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 3689

Un-Answered Questions { Data Warehouse }

How will you create interactive dashboards ?

911

What are the difference types of stages?

1214

How would you configure wh authentication?

952

I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?

2059

Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

970

Is it possible to join multiple Databases in a Catalog?

1120

How can you export a component’s internal parameters ?

2392

What is datastage?

1083

How to start a workflow using pmcmd command?

1250

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1169

my source is junk data how will u remove that junk data by using unix please any one replay me

3704

Explain lookup transformation is active in informatica

1104

Slowly changing dimensions, types and where will you use them

1713

What is a rank transform?

1084

Explain pmcmd command usage in informatica

1131

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