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

After we create a scd table, can we use that particular dimension as a dimension table for star schema?

1 1062

What is dimension modeling?

1 1209

What is the difference between mapping parameter & mapping variable in data warehousing?

1 1057

Where the cache files stored?

1 1074

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1 1151

How can we run the graph? How can we schedule the graph in unix?

1 1007

What is the difference between star and snowflake schemas?

1 1333

What is loop in data warehousing?

1 1214

How do you create surrogate key using ab initio?

1 1060

What are fact, dimension, and measure?

1 1426

What are the difference between snow flake and star schema?

1 1072

How can we schedule the graph in unix?

1 1050

I have two universes created by two difference database can we join them in designer & report level? How

1 1057

What is critical column?

1 1275

What is "method/1"?

1 1168

Un-Answered Questions { Data Warehouse }

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2425

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2168

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

1202

Write the unconnected lookup syntax?

1139

how to generate the test data in sas without input data? : Sas-administrator

1194

What is a rollup component? Explain about it.

1232

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1951

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1654

draw informatica architecture 8.6 ?

3939

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2122

Explain how to generate iqd file from framework manager?

1010

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

2289

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

1133

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2099

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2253

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