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 7305

what is time dimension? and how to populate time demension

TCS,

2 11866

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

2 15534

what is initial load and incremental load

ADP,

3 32127

what are the row and column separations in Flat Files

CTS,

3 8752

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

1 1973

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

Steria,

6 27699

sample mappings for scd1,scd2 and scd3

Cognizant,

2 20937

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.

1 2259

Tell different ways to create Macrovarible?

Accenture, PharmaNet i3,

3 8888

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

Wipro,

1 5478

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 14110

Can we specify checkpoints without Phases?

IBM, Tech Mahindra,

3 16379

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 12505

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

IBM,

4 19753

Un-Answered Questions { Data Warehouse }

What is node? How many nodes and amps used in your previous project?

1179

draw informatica architecture 8.6 ?

3949

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2067

create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

2817

Are you involved in writing the inferential analysis plan? Tables specifications?

4019

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212

How do you remove duplicate records in informatica? And how many ways are there to do it?

1234

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1103

Have you have ever worked in unix environment and why it is useful in datastage?

1217

Hi friends, what are the new features in abinito3.0?

2860

How would you format some text using css to be verdana and bold?

1150

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1998

What is the purpose of Dataware Control?

1121

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1200

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2304

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