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 13337

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 8523

explain merge dimensions with real time in DWH?

IBM,

1 8288

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

 3 7274

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 7593

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 4573

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

 2 7391

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

 3 7500

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

21 21868

what are the similarities between ROLAP and MOLAP

Siemens,

2 13648

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 11203

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

 1 3687

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 7653

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 6360

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 6926

Un-Answered Questions { Data Warehouse }

What a static and local variable?

583

Define mapplet?

622

What are different types of joins that are possible in obiee rpd?

496

What is grain of fact?

539

Explain what is analytical or analytic mean?

579




What are attribute roles?

544

Is microstrategy desktop available in other languages?

593

What is difference between primary key and unique key constraints?

564

name the sub-tabs which are in advance tab of ti?

5

differentiate between two-tier, three-tier and four-tier connections.

529

What is meant by a Parsing Engine?

701

In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?

593

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1328

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4207

Syntax for case when statement?

605

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