Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is shift table? have you ever created shift that?

Accenture, Clinical Research, Quintiles,

2 26516

Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

CTS,

6 7268

can i call router is a passive transformation

2 4956

what is the difference between filter and router transmissions

2 5479

how can i provide security to my reports in report studio?

TCS,

3 6009

what is work of PUSH DOWN option

Wipro,

2 6228

who to split dimentions into sub dimention

Wipro,

3 6373

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 3724

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

Wipro,

10 13597

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?

5 8355

It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha

1934

what is reprompt?

TCS,

3 17846

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

CTS, IBM,

3 20873

what is DSS?

3 5106

hi, while opening the cognos8 in ie,the home page is coming,while clicking the report studio the blank page will come after it will showing the home page.But by clicking the cognos connection,Query studio in the same page it's open successfully. only for the report,analysis,event studio is not working properly.i didnot understanding the problem.Iam using the cognos8.1 and sql server 2005.and also checking the cognos connection by clicking the run and its success. Any one Knows pls tel me in detail,becoz its very important iam working in report studio...

2 3494


Un-Answered Questions { Data Warehouse }

What are the mapping paramaters and maping variables?

564


What is the difference between junk dimension and degenerated dimension?

554


Whats there in global repository

1260


If a variable contains letters or special characters, can it be numeric data type?

755


Why does microstrategy object manager search for object dependencies?

594






What are the 3 components in sas programming?

717


what are the component of range? : Sas-bi

612


What do you understand by the term 'aggregate advisor?'

537


Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1467


What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5262


What are the different options associated with dsjob command?

931


describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

1895


What are components of report studio?

529


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

1703


Can you explain players in datastage?

701