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

I have a few records just I want to store each records tow times in target how?

Polaris,

2 7478

What is diff between Junk dimensions and conform dimension?

Polaris,

4 12566

how can i invoke pmcmd in command line prompt

1 4714

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2019

i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?

2 6308

i have 2 session s1 execute s2 load first session fail what is the reason?

L&T,

1 5935

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

Polaris,

7 10629

without update strategy how to insert &update?

DELL,

1 6710

what are the deliverables?in your project?

DELL,

2163

can u any challenge your project?

HP,

2043

without dynamic lookup how to insert new rows and update existing rows?

HP,

1 5510

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

iNautix,

8 12668

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

Fidelity,

4 8650

Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 8878

What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.

4 7404

Un-Answered Questions { Data Warehouse }

what is the use of materialized view?

1583

What is the max core of a component?

1116

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2143

What are the advantages of using sas?

1157

Explain is there any default username & pwd for bo designer & supervisor?

1024

Which lifecycle we will use for reporting?

989

How the ipc stage work?

1144

What's the difference between timestamp (0) and timestamp (6)?

1209

EXPLAIN SCD

1421

Can you explain surrogate key?

1059

What is the enterprise class platform architecture of cognos 8?

1041

What are the kinds of layouts does ab initio supports?

1013

what other sas products have you used and consider yourself proficient in using? : Sas programming

1132

What is source qualifier transformation in informatica?

1026

What Proc glm does?

1097

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