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 r the claims? how many type of claims we face from client side?

1 4342

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

TCS,

2 13028

what is the difference between static and dynamic

TCS, Wipro,

4 25596

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

IBM, TCS,

17 43551

what is the difference between Cognos EP7 series and Congos8?

Hexaware,

2 10464

How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?

Genpact, iFlex, TCS,

7 35867

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?

Cap Gemini, iFlex,

7 25636

What is the basic relationship between measures and dimensions in transformer modelling

5 9738

in which situations do u go for snowflake schema ?

TCS,

2 8531

in which situations do u go for starflake schema ?

TCS,

6 19889

in which situations do u go for scds ?

TCS,

3 9044

in which situations do u go for sequence generator ?

TCS,

2 9576

how do u get the first record from 50,000 records ?

TCS, UBS,

10 19866

what is incremental loading ?

CTS, IBM, Oracle, TCS,

12 57783

how many tasks are there in informatica ?

DELL, iGate, TCS,

15 51070

Un-Answered Questions { Data Warehouse }

To save time, can many reports be run at the same time?

1054

What is the difference between Data Warehousing and Data Mining?

1073

Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

943

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?

1047

What the difference between “look-up” file and “look is up” in abinitio?

1373

Define the slice and dice?

1022

What are the advantages of cognos?

994

what are the best practices to process the large data sets in sas programming? : Sas-administrator

1040

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1055

What is bteq script in teradata?

1169

How to join multiple db in catalog?

1029

Explain Association algorithm in Data mining?

2320

What are the components of datastage?

1139

Explain the situation where you have applied SCD in your project?

2060

Explain swot analysis?

1179

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