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

Diff between proc sql merge and join?

HSBC, Sristek,

1 4490

How many tiers in sas architecture?

2 5864

data task; input id date date9. visit; cards; 101 01jan2015 1 101 02jan2015 2 101 06jan2015 3 102 04jan2015 1 102 07jan2015 2 102 12jan2015 3 103 06jan2015 1 103 13jan2015 2 ; run; write a program to find out missing dates between visits by each subject.

1 2853

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

iGate, Thirdware,

4 8309

can we insert list report in corsstab report?

JPMorgan Chase,

1 4006

i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?

JPMorgan Chase,

1 3994

What is deployemnt groups, Lables, query and dynamic deployment group.

IBM, SVP,

1 3930

can we create master detail report where master and detailed container is separate?

JPMorgan Chase,

2 5262

which table we load first in DW. dimension or fact? why?

IBM, JPMorgan Chase,

4 7908

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

JPMorgan Chase,

4 8819

what is stacked chart , Bar chart, Column chart?

Tech Mahindra,

1 3506

A report is taking few seconds to run.The same report is taking very long time on the next day without doing any kind of changes in the report. What could be the reason? how do you tune the report.

Infosys,

1 5232

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 .

Amazon,

1946

Anyone suggest where can i get SAP Business Objects dumps for the below: C_BOE_30 C_BOWI_30 C_BOWI_40 C_BOBIP_40 C_BOBIP_41 C_BODI_20 C_BOSUP_90

CSC,

1 2985

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

TATA,

1 3464

Un-Answered Questions { Data Warehouse }

What is the purpose of pivot stage?

1168

What are cubes and olap cubes?

985

What are the 5 phases in a multiload utility?

1036

Explain what sort of existing documents should business analysts refer to when starting on a new project?

1009

In how many ways we can create ports?

1123

Why teradata is used?

1008

What is the difference between operational data stage (ods) and data warehouse?

1243

Define Merge?

1319

Define the slice and dice?

1011

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2930

What is report template in b.o?

1012

Explain 4gt switch. Does it have any drawback?

969

Describe 5 ways to do a “table lookup” in SAS?

1154

Mention the difference between ‘macros’ and ‘prompt’?

1148

How many project sources we can create in metadata?

1091

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