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 16926

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

IBM,

1956

what is function of retain statment

PPD,

2041

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

CTS,

1 4587

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 5115

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 3706

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 5063

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,

1620

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

Nationwide,

2057

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

1726

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

1900

Un-Answered Questions { Data Warehouse }

I have two universes created by two difference database can we join them in designer & report level? How

984

Explain difference between view and materialized view?

961

How do dates work in sas?

1139

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8120

Explain pushdown optimization $pushdownconfig parameter - informatica

1147

Where we use surrogate key explain with example?

1132

Have you used the rollup component? Describe how?

1121

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2722

How many numbers of sessions can one group in batches?

1064

What are the components used in web tier?

992

How to read an input file in sas?

1144

what is requery in cognos?

2483

Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

2029

How to convert a numeric variable to a character variable?

1209

What is the difference between mapping parameter & mapping variable in data warehousing?

989

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