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

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

Accenture, Clinical Research, Quintiles,

2 27637

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

CTS,

6 9044

can i call router is a passive transformation

2 6073

what is the difference between filter and router transmissions

2 6601

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

TCS,

3 7184

what is work of PUSH DOWN option

Wipro,

2 7406

who to split dimentions into sub dimention

Wipro,

3 7474

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 4352

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

Wipro,

10 16618

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

5 10313

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

2505

what is reprompt?

TCS,

3 19172

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 22125

what is DSS?

3 6300

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 4653

Un-Answered Questions { Data Warehouse }

Define enterprise data warehousing?

1204

Where do the datastage jobs get stored?

1216

what is log in cognos?

1200

What are the stages in datastage?

1083

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3794

If a variable contains only numbers, can it be a character data type?

1085

What is workflow manager?

1047

name the different procedures within ti?

What are the main components of teradata system?

1135

What is teradata? Also, list out some of the primary characteristics of teradata.

1058

Explain data flow graph with an example?

1127

What are the factors on which storage of data depends?

1166

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

1009

What function should we use to display the value entered or selected by a user in response to a prompt?

989

What is the use of cognos decision stream?

1093

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