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 to find out no. of business days in a month using macros.???(excluding weekends and holidays).

HSBC,

2 10685

what is the difference between x=substr(name,1,2); and substr(name,1,2)='x';

HSBC,

3 11943

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

Cognizant, HCL, TIAA CREF,

8 28695

Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.

IBM,

2 6489

how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

Cognizant, HP, TCS,

3 12483

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

Accenture, Rolta, TCS,

2 10408

I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?

Cap Gemini, HSBC,

1 6716

What is Cardinality b/w Fact to Fact?

IBM,

4 10281

What is portal page?

TCS,

5 8706

What is highest missing value for numeric?

1 8047

Any one suggest me best SAP Business Objects XI Online Training institute from India

Aetna,

2 5571

What is the difference between SI and JI?

2 7560

I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

Cap Gemini,

4 14000

I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 10292

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

IBM,

1 8570

Un-Answered Questions { Data Warehouse }

What is data stream and data adapter is it same are different?

991

Why do you use Mapping Parameter and mapping variable?

1776

what is a prompt value in report studio and variables ?

2718

What are the possible data marts in retail sales?

1001

difference between informatica 8.1.1 and 8.6

3683

Explain the purpose of substr functions in sas programming.

1068

a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

2471

What is m_dump?

1240

What is the purpose of _character_ and _numeric_?

1069

How many Key we can define in remove duplicate stage?

1393

What is edw?

1204

EXL informatica Questions

1396

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

969

List some pros and cons of amazon redshift?

what is repositery?

1853

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