1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

DataStage Scenario based Interview Questions

 1 15344

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

IBM,

1536

what is function of retain statment

PPD,

1522

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

CTS,

1 3687

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

 1345

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 4138

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

CTS,

1 2105

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

 1278

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 3074

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 3982

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

Tech Mahindra,

974

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,

1165

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

Nationwide,

1552

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

 1267

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

 1464

Un-Answered Questions { Data Warehouse }

What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

2148

How do you promote a non-reusable transformation to reusable transformation?

658

How substr function works in sas?

699

What is the purpose of cluster analysis in data warehousing?

561

What is level based metrics.how will you create it?

465




Can we start and stop single session in concurent bstch?

525

How can you first report in Business Objects by using broadcast agent?

2596

Is union transormation is active transformation?

586

Explain me what is vldb?

519

Differentiate between datastage and datastage tx?

593

What is dimensional table?

619

What do you mean by derived metrics?

595

Where do you see different stages in the designer?

628

Explain me what are data marts?

594

How we can decided drilling options for an attribute?

532

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