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

Can I create one wrkflw which will run different wrkflws on schedule time?

3 6684

Hi everyone, In my report i have ten pages like page1,page2, upto page10, i have textbox prompt when i enter 1 page1 should display,when i enter 2 page2 should display,can anyone suggest the answer.

4 9065

What is criteria for adverse events and treatment-emergent adverse events?

Accenture,

2 18045

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

Cap Gemini,

11 21698

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

TCS,

2 6793

suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me

2 5627

source file contains 100 records, i want 10 records in target file how it possible in datastage

IBM,

6 24756

hello, tell me the function which removes spaces from decimal field?

2 24349

what is song in infrmatica...?

CTS,

2337

if u having 2 pakages i want a report with report items in 2 pakages how to use the 2 pakages in single report please ans me............

Mphasis,

1 5424

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1965

if u generate a cube r pakage then its published we open in cc its ask every time for username &pass word?what we do?the pak r cube was not asking the password? what we do for this problem?pls ans me.............

1 4175

what do u mean by bridge group? where we r using this one?

2048

how many facts and dimensions in ur project and query items,how u deliver ur report to end users..i am going with fake exp...pls ans me generally what to ans..

Wipro,

2 7108

Cleared COG-112 with 100% score today. What next certification should i go for?

IBM,

1892

Un-Answered Questions { Data Warehouse }

What is a datastage job?

1065

What are the main services provided by application tier?

1035

What is Session and Batches?

1163

what is the use of sas management console? : Sas-di

1150

WHAT ARE THE DISTNICT VARIABLES?

2323

What does de-partition mean in abinitio?

1343

What are the designer tools for creating transformations?

1162

What is job control?

1213

What is a core dimension?

1125

What is the difference between datastage and informatica?

1190

What is sandbox?

1266

Which transformation we use to convert 'NA' to 'Not Available'

1319

How to specify variables to be processed by the freq procedure?

1124

how you provide security to reports? How you provide security to packages ?

1124

What are the different formatting types?

1128

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