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 13358

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 8550

explain merge dimensions with real time in DWH?

IBM,

1 8301

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

 3 7293

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 7623

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 4581

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

 2 7407

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 21976

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 11232

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

 1 3694

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 7696

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 6386

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 6958

Un-Answered Questions { Data Warehouse }

What is the purpose of trailing @ and @@? How do you use them?

613

Where do the datastage jobs get stored?

735

Explain constraint based loading in informatica

661

Explain parsing engine in teradata?

595

Tell me what is degree of a relation?

524




Define slowly changing dimensions (SCD)?

615

Where is metadata stored?

623

If RDBMS is halted what will you do ?

1708

Explain PDE.

608

r u done any partitions in ur project?

1407

What is the difference between passive stage and active stage?

824

Describe primary index in teradata. And what are the available primary index types?

547

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1559

What is ibm datastage flow designer?

687

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

819

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