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 do you load 10 different sources with 10 different layouts to 10 different tables?

TIAA CREF,

1 7374

what is the difference between cubes and package in cognos

Cognizant,

4965

What is the difference between List and Cross tab? Could some on explain with an example..

Barclays,

2 7404

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

Barclays,

2 8301

Which one among Star and snowflake schemas will occupy more space?

Barclays,

1 8365

what is operator combinality in datastage?

TCS,

1 7531

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

IBM,

2 6941

Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

IBM,

1 5889

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

IBM,

3 9121

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

Cap Gemini, IBM,

2 9642

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

CGI,

2506

Can we use two different sources in webirich client to create A report ? Like universe and excel etc...

PWC,

3 7887

WHAT IS INPUT CONTROL IN BO?

PWC,

3 10720

IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?

Accenture,

1 7465

i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.

1 4526

Un-Answered Questions { Data Warehouse }

How are models actually derived?

2014

What does edp stand for?

1172

What is Discover and Execute in XMLA?

2427

How and where you used hash file?

1189

What is meant by metadata in context of a data warehouse and how it is important?

1218

What are all the types of hierarchies?

1145

How can we remove the duplicates from flat file source?

1049

What are the components used in web tier?

1002

if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

1081

What is a partition and what are the different types of partition components in abinitio?

1288

Why union transformation is an active transformation?

1053

What do you mean by static prompt report?

998

What are the types of presistent cache in look up tr.

2068

What is the difference between an operational datastage and a data warehouse?

1165

Explain how you can run a graph infinitely in ab initio?

1129

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