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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

DataStage Scenario based Interview Questions

 1 15301

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

IBM,

1531

what is function of retain statment

PPD,

1513

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

CTS,

1 3668

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

 1333

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 4121

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

CTS,

1 2100

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

 1268

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 3050

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 3957

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

Tech Mahindra,

965

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,

1155

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

Nationwide,

1542

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

 1255

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

 1451

Un-Answered Questions { Data Warehouse }

What are the programs that we can do with the microstrategy architect?

558

What are public objects?

631

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

539

What are the types of containers?

667

What are the difference types of stages?

610




What is scd type 1 and 2.

501

What are the data types in sas?

596

What are the steps to build the datawarehouse?

575

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1618

What is an enterprise?

596

What is the difference between the content store and content manager?

558

What is the difference between check point and phase?

676

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

1890

Difference between server jobs & parallel jobs?

638

Notification Activity

888

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