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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

h0w many versions have been developed of onformatica so far?

TCS, TetraSoft,

1 2415

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

Patni,

5 8665

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

Patni, Tech Mahindra,

2 8706

What are Dashboard reports?And significance of these in analysis?

 1 2178

How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.

 2 4405

How to get second top scorer student from a class- table having different sections A, B, C & D? each section has same number of student.

TCS,

4 7164

how lookup is acting as both active and passive ? how is it possitble?

TCS,

9 57256

can any one pls send me the project flow at the time of interview

 1703

can any one tell me how to create a new universe from scrach with step by step process.

HCL,

4 7774

How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?

Reddy Labs,

3 6376

what is the primary variable in your study?

Accenture,

3 13917

what are all the reports you generated in your recent project?

Accenture, Quintiles,

1674

Did you used proc test? when?

Accenture, Quintiles,

1571

Did you used proc lifetest? when?

Accenture, Parexel, Quintiles,

2 9005

In proc transpose and data step with arrays which one you pick?

Accenture, Quintiles,

2571

Un-Answered Questions { Data Warehouse }

How to find duplicates in a table?

607

To save time, can many reports be run at the same time?

589

how we can load rejected record's at run time?(not through bad files)

1906

Name the types of report?

550

Define catalog in cognos and write its various types?

610




Why do you need stage variables?

657

Explain the term 'database' related to relational database management system?

569

How to create a non-reusable instance of reusable transformations?

674

what are the different authentication modes available in microstrategy?

582

What do you mean by parsing?

625

What is the purpose of joins in teradata and what are the available join types?

540

What do you understand by ‘ibm predictive maintenance and quality’?

561

How to extract sap data using informatica? What is abap? What are idocs?

550

Explain why are oltp database designs not generally a good idea for a data warehouse?

621

Explain what are the advantages and disadvantages of reporting directly against the database?

564

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