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

Where do i get Free COGNOS 8 Certification Dumps Downloaded for these codes COG-105, COG-112, COG-122, COG-125, COG-132, COG-135, COG- 142, COG-145, COG-180, COG-200, COG-205, COG-300, COG-310, COG-400, COG-480

7 14672

how to identify new and old values in source qualifier or any other transformations using informatica

2 6057

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 27825

It is possible to give 2 query items has measures in cross tab?for ex:row as products,column as year and measure as revenue,sales year....like that.It is possible r not ?If it's possible pls tel me the process....

2 4610

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

Wipro,

3 7169

How to do performance tunning of reports?

2314

Where do we use ACvisitor class?

2519

What property you use to Hide a control at runtime?

2 5727

How do you design a report which has multiple child datastream (horizontal seq)

2601

How do we have left -right flow , normally its top-down flow

1 6079

How can you change the group key dynamically?

L&T,

1 4514

What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

Mphasis,

2 6749

How to fix the order of Prompts? How to assign the default value in prompt?

Mind Tree,

2 7821

What is the difference Between Mapping parameter and variable

Accenture,

3 10596

What is update override?

Accenture,

1 6964

Un-Answered Questions { Data Warehouse }

Can you define materialized view?

1045

What is the difference between using drop = data set option in data statement and set statement?

1160

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

2117

Explain what is partitioning? What are the types of partitioning?

973

What are initial page components of Cognos connection?

1013

What is execution plan?

1201

What are level metrics? Why are they needed?

1039

Fact table is in normalized or de-normalized form?

960

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1059

How many dimensions are there in informatica?

1085

What are the types of data warehouses?

1526

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1746

Explain teradata architecture in detail with a diagram.

1113

draw informatica architecture 8.6 ?

3871

What are the applications primarily used by business analyst? : Sas-bi

994

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