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 14499

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 10159

explain merge dimensions with real time in DWH?

IBM,

1 9008

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

3 8451

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 9297

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 5219

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

2 8337

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

3 8701

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

21 26894

what are the similarities between ROLAP and MOLAP

Siemens,

2 14764

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 12312

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

1 4353

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 9708

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 7552

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 8944

Un-Answered Questions { Data Warehouse }

Explain fact degradation?

998

Explain fallback in teradata?

1067

Explain what is the limit to the number of sources and targets you can have in a mapping?

1005

What is the difference between group and associare?

1050

Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1839

What are the mapping paramaters and maping variables?

1038

What can be achieved by using the teradata rdbms?

1044

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2052

What are the challenges you faced while making of reports?

848

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2188

Have you ever used the SAS Debugger?

1766

Does microstrategy intelligence server run on windows®, unix®, or linux®?

978

How many transformations can be used in mapplets.

1940

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1948

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7078

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