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

what type of transformation is not supported by mapplets?

CTS,

4 15858

Tell me the Top 10 features of oracle that supports datawarehousing.

CTS, IBM,

2 8220

How will you update the row without using update statergy?

CTS,

10 15355

How will you update the first four rows and insert next four rows in a mapping?

CTS,

5 11156

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

Wipro,

1 8399

any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 4139

how to join the 2 different table with different columns in informatica?

Accenture,

5 23978

How to load the source table into flat file target(with columns) in informatica?

Accenture,

4 17904

Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both

Hexaware,

2 6677

In operator is used in which transformation in informatica 8.6.0

Virtusa,

5 20965

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

IBM,

5 12051

What is the aggrigate navigation ? can anybody explain me with some practical example?

1 5640

What is drill across ? can anybody explain me in detail?

1 5480

How we can resolve the loops by using the Aggrigate Awareness?

Hexaware,

1 3591

How to create Index to the table in the universe designer and how it improves the Query performence

1 2629

Un-Answered Questions { Data Warehouse }

Hi friends, what are the new features in abinito3.0?

2860

What is the purpose of Dataware Control?

1119

Explain scd type 3 through mapping.

1071

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1239

Are you involved in writing the inferential analysis plan? Tables specifications?

4019

What r the names of the reports that you prepared?

1029

what are the names of the reports that you prepared?

1193

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2175

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2311

how to generate the test data in sas without input data? : Sas-administrator

1202

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421

Have you have ever worked in unix environment and why it is useful in datastage?

1214

How to create the source and target database connections in server manager?

1144

faq's on cognos

4112

How do you remove duplicate records in informatica? And how many ways are there to do it?

1232

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