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

What is PX?

IBM,

2 7166

what is time dimension? and how to populate time demension

TCS,

2 11722

How do you load dimension data and fact data? Which is first

2 15430

what is initial load and incremental load

ADP,

3 31937

what are the row and column separations in Flat Files

CTS,

3 8615

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1916

What is the difference between Generate Records Component and Create Data Component?

Steria,

6 27391

sample mappings for scd1,scd2 and scd3

Cognizant,

2 20800

Hi friends please reply what will be the answer to following question in crystal report 1)Difference between the CR8.5 & CR10.5(withing VS2008) in terms of features. 2)Is Hierarchy of grouping features in either CR8.5 or CR10.5. what are its limitation i.e maximum no's can be created. 3)Scenario - If I have a string semicolon separated(1000 in nos) then how to pass it into Record Selection formula or parameter. 4)Scenario - If user want to do dynamic grouping at runtime that to while designing report only 1 group was created and as per user at runtime based on user selection different fields are used to create group. How is it possible. (Is it possible through formula?) 5)what is cascade or dynamic prompting.whether this is a feature of CR8.5 or CR10.5. 6)what to answer for question "How would you start crystal report development" 7)How "set location" is useful & how to implement it. 8)Scenario - At design time report was developed using MS SQL as datasource but at client side they are using Oracle which is having same table name and structure will the report work? If yes what changes are required to do so. 9)when does "Table Not Found" error is generated.

2195

Tell different ways to create Macrovarible?

Accenture, PharmaNet i3,

3 8744

In how many ways we can apply the security to a cube in Transformer? Explain?

Wipro,

1 5385

i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

IBM,

8 13812

Can we specify checkpoints without Phases?

IBM, Tech Mahindra,

3 16218

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

Patni,

5 12293

Can you read multiple input files using one input file component ?(same DML)

IBM,

4 19524

Un-Answered Questions { Data Warehouse }

Explain what is a view as it relates to system modeling?

1002

what is the procedure for scheduling conditional rendering?

2538

What is target designer and target load order?

1122

Describe the function and untility of the most difficult SAS macro that you have written.

2240

Why do you think data processing is important?

1144

Why cognos scenario is used?

1080

How to load last n records of file into target table - informatica

1091

What is meant by a Highest Cost Plan?

1077

What is the difference between agglomerative and divisive hierarchical clustering?

1198

What is derived metric?

998

generate date / time dimension in informatica

1137

How we can covert server job to a parallel job?

1170

Explain the different kinds of facts.

998

What are the different methods ot loading a dimension table? A fact table etc?

1053

How to handle decimal places while importing a flatfile into informatica?

1202

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