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

which r the connectors used in san?

2188

what is the generated prompt,how can i use?

5 19814

how much memory space occupied real time project (roughly)?

2222

What is mean by tuning the report?

1 3269

what are they different types of report in BO?

6 32334

How do scheduling the report in BO XIR2? can you say what are they steps?

5 11923

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 27129

I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!

3 9547

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

BirlaSoft,

5 15247

What are set operators in Oracle

Deloitte, Wipro,

3 17120

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

Deloitte,

9 19296

from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

Deloitte,

21 40053

why sequence generator should not directly connected to joiner transformation ?

ANZ,

1 10747

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 5125

What is Target Update Override? What is the Use ?

Patni,

8 19833

Un-Answered Questions { Data Warehouse }

Difference between server jobs & parallel jobs?

1076

When do we analyze the tables?

967

What is the roundrobin collector?

1099

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1128

How is MLOAD Teradata Server restarted after execution?

1264

What are attribute roles?

974

How to import vsam files from source to target. Do we need a special plugin?

935

What are the design methods of data warehousing?

950

What are the business intelligent tools to which Redshift can be integrated with?

How to create Index to the table in the universe designer and how it improves the Query performence

2553

What is defined as partial backup?

1075

What is data movement mode in Informatica and difference between them?

1137

What is the difference between absolute filtering and standard filtering in microstrategy?

979

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

991

What is ibm datastage flow designer?

1149

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