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 are the difference between sas functions and procedures?

1155

What are all the different types of prompt in cognos?

1051

What are the types of folder present in cognos?

1097

What do you mean by drill through report?

966

What do you mean by drill across?

1148

What is defined as data mining?

1035

When we save a report in report studio with what extn it save?

1066

What are all the types of hierarchies?

1137

What is called cognos reporting tool?

1048

What are the ways to import data into catalog?

1084

What is the use of cognos decision stream?

1093

What is set to be cardinality?

1174

Mention the difference between ‘macros’ and ‘prompt’?

1148

What are the components of report net?

1266

What is the difference between metadata and data dictionary?

1141

Un-Answered Questions { Data Warehouse }

In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1984

What are the tasks that source qualifier perform?

1106

Suppose we want to display zero when null values coming to report how can we do that?

926

How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?

4400

how to load dimension table and fact table. plz tell me the steps.

2094

What is the difference between group and associare?

1048

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

996

Define data aggregation?

1099

Explain conformed fact?

964

differentiate between power play transformer and power play reports?

Enlist the tasks for which source qualifier transformation is used.

1040

Can you define a datastore in cognos?

1039

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1084

What are the components provided on node?

1042

Explain meta data?

1032

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