Data Warehouse Interview Questions
Questions Answers Views Company eMail

in oracle write query yourname+1 from dual

5 5960

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

1 3418

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 10506

what is proc Index? and what is proc document?

Mind Tree,

1974

what is the prob plot in clinical domain

TCS,

1 3953

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 7910

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

1582

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

1684

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 14651

what is the difference between stop and abort

2 4595

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

Cap Gemini,

7 27674

tell me about your project functionality

1842

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

1 3121

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

1472

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

1 2927


Un-Answered Questions { Data Warehouse }

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2134


what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

601


What versions of SAS have you used (on which platforms)?

993


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1821


What are pdv and it functions?

574






How to create a non-reusable instance of reusable transformations?

654


What is dimensional modeling?

569


What is ab initio enterprise meta>environment (eme)?

859


how could you generate test data with no input data? : Sas programming

593


how do u implement configuration management in Informatica?

4346


Differentiate between sas functions and sas procedures.

617


Different circumstance which drives informatica server to expel records?

531


Is olap services sold as a separate product?

496


any one answer me how they can analyzing the project using data ware housing?

2004


Can you please send me the migration related issues .

1611