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 7156

what is time dimension? and how to populate time demension

TCS,

2 11705

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

2 15411

what is initial load and incremental load

ADP,

3 31916

what are the row and column separations in Flat Files

CTS,

3 8598

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

1908

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

Steria,

6 27377

sample mappings for scd1,scd2 and scd3

Cognizant,

2 20788

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.

2188

Tell different ways to create Macrovarible?

Accenture, PharmaNet i3,

3 8720

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

Wipro,

1 5376

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 13783

Can we specify checkpoints without Phases?

IBM, Tech Mahindra,

3 16203

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 12263

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

IBM,

4 19508

Un-Answered Questions { Data Warehouse }

Explain in detail about type 1?

1678

what is object level locking ? where do appear this type of locking ?

3503

Explain sessions?

1073

Enlist the tasks for which source qualifier transformation is used.

1044

What is meant by drill down?

979

Explain what is etl process? How many steps etl contains explain with example?

896

what is the use of structures?how many nodes can u create in a structure?

2239

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

10404

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

2495

What is powercenter on grid?

1184

We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

1443

how to test reports in cognos?

1033

in sap bi we have wad, then why we go for sap bo

3383

How are the sources and targets definitions imported in informatica designer?

1111

What is clusterservices in obiee ? Why its used?

928

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