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 7471

What is diff between Junk dimensions and conform dimension?

Polaris,

4 12560

how can i invoke pmcmd in command line prompt

1 4710

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 6304

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

L&T,

1 5934

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 10618

without update strategy how to insert &update?

DELL,

1 6710

what are the deliverables?in your project?

DELL,

2161

can u any challenge your project?

HP,

2043

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

HP,

1 5507

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 12654

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 8647

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

4 8875

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 7400

Un-Answered Questions { Data Warehouse }

How to schedule the report in b.o?

1051

what is the use of structures?how many nodes can u create in a structure?

2250

Explain three-tier connection?

970

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1989

What is workflow? What are the components of the workflow manager?

1155

explain the function of substr in sas? : Sas-administrator

1026

How to create prompts in report net?

999

What specific features and functionality do I get with olap services?

966

What is a datastage job?

1025

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

2019

What are the benefits of datastage?

1248

What are dimensions?

1074

what is the difference between nodup and nodupkey options? : Sas programming

1208

Can you define framework manager?

1040

What are the different models used in cluster analysis?

971

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