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

We had a number of reports scheduled to run at various times. This worked fine for at least a year, now it is the second time round we lost all the scheduled jobs, with no apparent reason we can find. Any ideas?

907

What is the difference between 'using group by in the sql of the report' and 'having a group section in the report'?

942

Where we use afc in actuate?

1028

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?

1044

What is data stream and data adapter is it same are different?

982

How to generate a report by getting values from two reports. The generated report should contain the 5 values of first report and last 5 values of second report?

977

What is afc?

979

What is data stream and data adapter is it same are different? Explain?

971

What is static and local variable?

1036

What is the main difference between schema in rdbms and schemas in datawarehouse?

1093

What is surrogate key? Where we use it explain with example?

931

Explain can a dimension table contains numeric values?

968

What is crass reference table?

1055

What is a fact, dimension, measure?

1209

Explain difference between e-r modeling and dimentional modeling?

990

Un-Answered Questions { Data Warehouse }

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10170

Copy ".roi" file of management console to another path of management console's folder using ".rox" file. or any command of actuate. Is it Possible? if Yes then pls give me Example.

2924

What is Online View?

1960

Explain lookup transformation source types in informatica

1099

Give some information on report bursting?

994

How do we call shell scripts from informatica?

1121

How to create repository in abinitio for stand alone system(local nt)?

1224

how do the in= variables improve the capability of a merge? : Sas programming

1436

What is the sql query overwrite in source qualifier in informatica

1091

Define different types of attributes in microstrategy desktop?

1241

in u r data u having duplicates how to fetch the latest data in our report?

5743

how could you generate test data with no input data? : Sas programming

1190

What is star schema and snowflake schema?

993

Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?

919

Explain difference between onrow and onread method?

915

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