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

If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

Wipro,

2155

what is option year cuttoff in sas

L&T,

2 7914

what is treatment emergent events and treatment emregent adverse event

2454

what is lifetest

Cognizant,

1 5219

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

Polaris,

4 8812

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

Accenture,

6 11555

What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.

DELL,

2 7758

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1925

1894

I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.

3 7592

Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?

TCS,

1 4721

i am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....

2 5208

actually my qus is i used some tables in my model,i published that to connection i use that one.at the same way my team member added some new tables and again he published how can i get my model in connection pls pls explain me..........

1 4107

actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1748

IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.

TCS,

3 13763

Un-Answered Questions { Data Warehouse }

Explain the difference between holap and rolap?

1032

Which studio is used to create reports?

1159

Explain how merging helps to combine data sets.

1117

What is defined as Query studio?

1177

Can there be sub steps of etl steps?

1107

Explain how many universes can be created in a project?

1124

What is a security filter in microstrategy?

1073

What is MPP in Redshift ?

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1130

Explain the difference between view and materialized view?

984

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2445

Explain what are non-additive facts in detail?

1091

What is different between the data warehouse and data mart?

1114

If a variable contains only numbers, can it be a character data type?

1146

what are the facilities provided by data warehouse to analytical users?

2124

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