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

can cubes contain measures ?

2036

can be used COM component in Informatica ?

2065

what is the advantage of persistent cache? when it should be used?

2 4778

when will use SQL override in a lookup transformation?

2303

Two different admin users created for repository are________and_________.

1 3922

Two default user groups created in the repository are____and_____.

2057

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

1870

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

2061

what is the difference between date cache and lindex cache?

1 3897

when should one create lookup transformation ?

2 5483

how do u handle performance issues in Informatica . where can u monitor the performance ?

4744

list and discuss two approaches for updation of target table in Informatica and how they are different.

2118

you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.

3 6364

where are the log files generally stored.Can you change the path of the file.what can the path be?

2447

where is the cache (lookup, index) created and how can you see it.

2018

Un-Answered Questions { Data Warehouse }

dimension object created in oracle can be imported in designer?how?

2993

how do you create schema objects in 2 tier connection?

962

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

1144

what are the tables used in health care domain project and columns used in report?

4516

What are the types of partitioning?

1051

What are the different versions of informatica?

1281

What is the difference between rollup and scan?

1881

Identifying the bottlenecks in various components of Informatica and resolving them.

1941

AWS Redshift is basically works on nodes and cluster and which of following option Redshift is based on?

How do you use reject loader.

2614

What is data cleaning? How can we do that?

1048

What is the difference between look-up file and look-up, with a relevant example?

1204

How to join three sources using joiner? Explain though mapping flow.

1155

What are global filter and how they differ from column filter?

975

Explain input and put function?

1148

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