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

We can have two separate installations of BOE XI 3.1 on a single server?

2 6078

Can we configure two instances of CMS pointing to two different CMS system databases?

2087

Diff b/w v2r5 and v2r6 ?

TCS,

3 11857

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

TCS,

2538

If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically

TCS,

6 14175

When we will go for Data elements?

TCS,

3 10661

what is the unix script to run the job? Please mention commands which we use often?

TCS,

3 20959

Difference in the implementation of lookup and join stages,in joining two tables?

TCS,

7 16913

How to create user defined environment varibale(parameter)?

TCS,

1 8205

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 7088

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 11675

please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

2249

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

IBM,

2464

what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?

Wipro,

12 30987

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 18840

Un-Answered Questions { Data Warehouse }

How do we resolve attribute roles in microstrategy?

1205

What is the difference between ‘macro’ and ‘prompt?

1150

How would you define the end of a macro?

1153

How many Key we can define in remove duplicate stage?

1447

Can informatica load heterogeneous targets from heterogeneous sources?

1238

What is sequence generator transformation in informatica?

1127

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.

2126

How is security handled?

1052

In how many ways we can create ports?

1162

Explain rw document?

1155

What is difference between data mart and data warehouse?

1021

Explain what is difference between query studio and report studio?

1054

What is enterprise data warehousing?

1107

Explain input and put function?

1188

Describe the between keyword in teradata?

1086

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