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 5972

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

2031

Diff b/w v2r5 and v2r6 ?

TCS,

3 11724

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,

2479

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 13924

When we will go for Data elements?

TCS,

3 10515

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

TCS,

3 20821

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

TCS,

7 16640

How to create user defined environment varibale(parameter)?

TCS,

1 8118

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 6995

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

2 11525

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

2194

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

IBM,

2421

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

Wipro,

12 30573

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

3 18666

Un-Answered Questions { Data Warehouse }

what is 'reconsideration error' and how can i respond to this error and how to debug this

2633

what is the main advantage of impromptu over cognos reportnet?

1039

Explain difference between zabo and webi?

1099

I have a few records just I want to store data in to targets cycling way how?

2363

Explain functional dependency?

1087

What is the use of PROC gplot?

1140

What is drilling across?

994

What is the difference between olap and oltp?

1057

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

2185

Explain the different types of views used in cognos.

949

What does PROC print, and PROC contents do?

1236

What are templates in which way it is help full?

996

Which version configuration tool used in ur project?

3258

How to extract sap data using informatica?

1042

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

4736

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