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

DataStage Scenario based Interview Questions

1 16920

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

IBM,

1954

what is function of retain statment

PPD,

2027

Limitation of REPLACESTR. Is there any character limitation to it.

CTS,

1 4585

Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

1947

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

CTS,

2 5112

Thanks to all people who are posting their comments...

CTS,

1 2685

In development project what is the process to follow for an etl developer from day1

1724

10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list  Rank  Running-count

Data Semantics,

1 3704

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

L&T,

2 5059

if i have a query as flat file how can we load data to target table

Tech Mahindra,

1398

if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

CTS,

1618

The question was on time stamp. what is the difference between HH and HH24 when to use when.

Nationwide,

2055

Please let me know how to make Data masking in informatica..

1721

Please let me know how to make encryption and decryption with example?

1900

Un-Answered Questions { Data Warehouse }

Can you fastexport a field, which is primary key by putting equality on that key?

1178

Define tm1 architecture?

What is a data processing cycle and what is its significance?

1217

what is xcelsius architecture?

4580

Have you ever encountered an error called “depth not equal”?

1161

What is a shortcut and copy in Informatica and how two are different with each other?

1196

what are input dataset and output dataset options? : Sas programming

1105

How identifying bottlenecks in various components of informatica and resolving them?

1132

Which command is used to save logs in the external file?

1098

What we will do with the universe for faster process?

982

What is meant by target load plan?

972

What is the metric store database?

968

What are cluster in redshift? How do I create and delete a cluster in aws redshift?

How can we use external procedural logic in informatica?

923

You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?

869

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