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

how will you move the universe/report from development to production?

3 14623

i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?

TCS,

5 10301

explain merge dimensions with real time in DWH?

IBM,

1 9096

how many times can use the union operator in a report?

3 8597

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 9478

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 5298

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 8438

How many tables can an universe contain is their any limit to insert tables in the universe?

3 8831

Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 27477

what are the similarities between ROLAP and MOLAP

Siemens,

2 14891

1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?

TCS,

2 12412

Hi Friends, I am planning to learn actuate tool by it self .... can u suggest me any examples to practise this tool.

1 4417

libname deepak 'C:\SAS Files'; proc format; invalue convert 'A+' = 100 'A' = 96 'A-' = 92 'B+' = 88 'B' = 84 'B-' = 80 'C+' = 76 'C' = 72 'F' = 65; data deepak.grades; input ID $3. Grade convert.; *format Grade convert. ; datalines; 001 A- 002 B+ 003 F 004 C+ 005 A ; proc print data = deepak.grades; run; I get the following output Obs ID Grade 1 001 . 2 002 . 3 003 . 4 004 . 5 005 . I don’t understand why Grade shows up as a missing value. Everything seems fine, including ID $3. Now, in case I use ID : $3. Or use column input, I get the desired output. Kindly help Deepak

7 9917

data voter; input Age Party : $1. (Ques1-Ques4)($1. + 1); datalines; 23 D 1 1 2 2 45 R 5 5 4 1 67 D 2 4 3 3 39 R 4 4 4 4 19 D 2 1 2 1 75 D 3 3 2 3 57 R 4 3 4 4 ; Idont understand what the (Ques1-Ques4)($1. + 1) means. I have seen (Ques1-Ques4)(4*$1.), but what is (Ques1-Ques4)($1. + 1)? Appreciate all help Thanks

3 7683

I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?

6 9119

Un-Answered Questions { Data Warehouse }

What are stage variables and constants?

1199

What is joiner transformation?

1067

If you could design your ideal job, what would it look like?

2985

Explain translate function?

1264

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

1168

What are the advantages and disadvantages of reporting directly against the database?

1022

What is difference between informatica power mart and power center?

1054

Define Merge?

1374

Explain the difference between informat and format with an example.

1222

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1769

what is stitch query in reportnet?

1158

How many tables can you join in v2r5?

1120

Name the types of transformation?

1011

Which component has onread method and what it is used for?

1033

How to load specific no.of records using bteq, or fastload,or multiload

1816

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