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

if we have a delimiters at unwanted places in a flat file how can we over come those.

2050

why should we go Teradata over Oracle,what is the main differences?

TCS,

4 12111

what is the hint? how to use it to reduce the query processing in program?

Cegedim,

3 7853

What are @FUNCTION?

4 7927

Why do we use QUIT commmand for proc datasets and proc sql ???

3 8970

1)Source file contains one record, I want 100 records in target file.

3 9328

Two source files contains same meta data third file contains different data types can I funnel that file.

2 8166

3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 6112

I have 100 records how can I load at a time from the single time

1 5284

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 6743

hi,can you please share with me about,what is reportlimit,report order and how can create and use

iGate,

1 5276

hi,can you share with me about,what is prompt order,how it uses and how it creates

1 5642

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 8901

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4048

How to schedule the report twice in a day?

Cognizant,

2 9990

Un-Answered Questions { Data Warehouse }

What is meant by alternate drill down with ex?

1095

Define query items?

1026

Explain do we need an etl tool? When do we go for the tools in the market?

1025

what is the cube size?

Is it possible to join multiple Databases in a Catalog?

1129

Explain what is redshift?

is it possible to export the webi reports to crystal reports?with out using businessview?

2304

what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

2081

What do you mean by Drill down and Drill Up?

1009

Is Redshift a row based storage or columnar based?

What are the primary usages of datastage tool?

1075

Explain what is the difference between business requirement document and use case document.

1031

Is there any other repository domains rather than universe, security, document?

1049

What is meant by incremental load?

1103

What is drill down and slicing and dicing whats the difference between them?

1080

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