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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

Cap Gemini,

6 12253

please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

 1658

1)How to Duplicate Records Delete in Sequential file?

IBM, TCS,

4 13245

can we join volatile table with general table an global temporary table with general table ?

IBM,

4 8652

how to restrict up to three levels in hierarchy when u do drill mode?

iGate,

3 6710

what are the tables used in health care domain project and columns used in report?

IBM,

4029

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

 1365

if we shortcut join between two tables what will be the output?that it will give all columns or same columns?

2 4332

In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;

 1 6373

How is Teradata in current market?

 4 7579

What are the issues you have faced in your project? How did you overcome those issues?

CTS, FEEE, TCS,

1908

How to create a report template BO XI R2

Infosys, LBM,

2 7984

From where you extract the data, how you did it into informatica? explain....

Accenture, Unisoft Infotech,

1 5260

What are your source in project and how you import in informatica? How can i explain abt this?

Accenture, Unisoft Infotech,

1 5771

What are events in workflow manager?

Accenture, IBM,

1 8063

Un-Answered Questions { Data Warehouse }

How many types of joins are there in teradata?

538

What security is provided with microstrategy desktop?

544

What are the partitioning techniques available in link partitioner?

1747

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

1913

Explain what are necessary tasks to install reportnet software?

477




Define catalog in cognos and write its various types?

610

What are the restrictions of union transformation?

566

How to handle multi value dimensions?

1772

How security is concerned with Reportnet? Explain its implementing steps.

1607

What is the difference in creating filters in designer and business objects?

580

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

534

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

1811

What is data analysis?

534

What do think which one is the better joiner or look up?

716

What are the different ways to represent the loading of dimension tables?

507

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