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,

2110

what is option year cuttoff in sas

L&T,

2 7792

what is treatment emergent events and treatment emregent adverse event

2407

what is lifetest

Cognizant,

1 5145

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 8631

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 11335

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

DELL,

2 7652

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

1878

1832

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 7434

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 4630

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 5104

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 4019

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.....

1699

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 13621

Un-Answered Questions { Data Warehouse }

Enlist the differences between database and data warehouse.

1121

What is the metadata extension?

1001

Explain etl?

982

How to create Target definition for flat files?

1227

What do you mean by the term data warehousing?

1073

Explain sessions and how many types of sessions are there?

1011

What is Redshift Spectrum?

What is proc sort?

1225

How do you truncate a table?

1174

How can users design dashboards quickly and without programming experience or training?

960

Explain the meaning of Amp?

1153

What is data cleaning? How can we do that?

1044

Name the five phases that come under MultiLoad Utility.

988

what is sas olap server? : Sas-di

1257

what is user variable in affinium campaign? and some real time examples.

4182

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