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 5805

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

1971

Diff b/w v2r5 and v2r6 ?

TCS,

3 11565

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,

2405

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 13633

When we will go for Data elements?

TCS,

3 10339

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

TCS,

3 20657

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

TCS,

7 16356

How to create user defined environment varibale(parameter)?

TCS,

1 8005

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 6899

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

2 11340

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

2140

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

IBM,

2341

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

Wipro,

12 30132

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

3 18476

Un-Answered Questions { Data Warehouse }

What are all the components of Report Studio?

1042

How do you verify a complicated sql?

1014

Which is the t/r that builts only single cache memory?

1130

What is etl process. How many steps etl contains explain with example?

896

write a query to retrieve the latest records from the table sorted by version(scd)

1011

What are the types of folder present in cognos?

1049

What is the enterprise class platform architecture of cognos 8?

972

What is update strategy transform?

1021

What is orabulk stage?

992

How to generate a report by getting values from two reports. The generated report should contain the 5 values of first report and last 5 values of second report?

929

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1468

What are the applications primarily used by business analyst? : Sas-bi

942

9. What was the most complex type of report you dealt with?

2156

What do you mean by query studio?

890

Your application mode has crashed. How would you run your i-server?

889

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