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 12278

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

 1661

1)How to Duplicate Records Delete in Sequential file?

IBM, TCS,

4 13272

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

IBM,

4 8669

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

iGate,

3 6719

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

IBM,

4035

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

 1371

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

2 4345

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 6386

How is Teradata in current market?

 4 7593

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 7991

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

Accenture, Unisoft Infotech,

1 5266

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

Accenture, Unisoft Infotech,

1 5778

What are events in workflow manager?

Accenture, IBM,

1 8071

Un-Answered Questions { Data Warehouse }

How can we increase the loading performance of oracle table in AbInitio?

638

Explain what is metadata reporter?

566

What are different types of metrics in microstrategy?

552

What are the default statistics that proc means produce?

598

How to use procedural logic inside infromatica?

631




How are the sources and targets definitions imported in informatica designer?

666

server hot-ws270 is connect to Repository B. What does it mean?

1853

How to test a cube?

1673

What is a full backup?

537

what are some differences between proc summary and proc means? : Sas programming

503

What is the difference in the way microstrategy handles custom group and consolidations?

559

Can microstrategy intelligence server scale easily and cost effectively based on my growing needs?

592

What is the basic syntax style in SAS?

612

What does Amp contain and what are all the operations that it performs?

585

Name the types of report?

550

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