1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

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

TCS,

3 13356

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 8545

explain merge dimensions with real time in DWH?

IBM,

1 8301

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

 3 7291

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 7617

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 4578

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

 2 7403

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

 3 7511

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

21 21926

what are the similarities between ROLAP and MOLAP

Siemens,

2 13659

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 11226

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

 1 3692

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 7684

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 6378

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 6956

Un-Answered Questions { Data Warehouse }

What is aggtorec restructure operator?

727

Explain what are the basic needs to join two sources in a source qualifier?

517

What is top business?

567

Explain what are slowly changing dimensions?

607

Can you explain cognos tm1?

5




Explain input and put function?

646

What is level prompt?

530

Explain conformed fact?

524

Write some methods to apply securities in framework manager model?

654

what is a prompt value in report studio and variables ?

2168

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

616

What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

3919

What is the difference between where and if statement?

619

What is aggregate table and aggregate fact table ... Any examples of both?

613

How do y read Sequential file from job control?

14414

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