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 6575

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 8904

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

Accenture,

2 17928

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 21316

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 6682

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 5525

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

IBM,

6 24498

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

2 24216

what is song in infrmatica...?

CTS,

2252

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 5348

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......

1926

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 4108

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

2006

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 7006

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

IBM,

1851

Un-Answered Questions { Data Warehouse }

Enlist the syntax rules followed in sas statements.

1096

what is the difference between nodup and nodupkey options? : Sas programming

1208

What is tracing level? How many types of transformations supported by sorted input?

984

what other sas products have you used and consider yourself proficient in using? : Sas programming

1128

What is the order of precedence of vldb properties?

1025

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

939

How many types of sorting methods are available in datastage?

1083

Explain the hierarchies level data warehousing.

899

Why AWS redshift is named after Redshift?

Can you pass sql queries in filter transformation?

1027

How to read the length of word in unix?

1389

what are the filters in framework manager and report studio?

1004

explain the function of substr in sas? : Sas-administrator

1026

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4740

In SAS explain which statement does not perform automatic conversions in comparisons?

1323

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