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 2419

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 8682

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 8718

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

 1 2183

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 4408

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 7170

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

TCS,

9 57278

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 7783

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

Reddy Labs,

3 6383

what is the primary variable in your study?

Accenture,

3 13932

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

Accenture, Quintiles,

1679

Did you used proc test? when?

Accenture, Quintiles,

1573

Did you used proc lifetest? when?

Accenture, Parexel, Quintiles,

2 9012

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

Accenture, Quintiles,

2572

Un-Answered Questions { Data Warehouse }

What is the difference between writing a joiner query in ANSI style and THETA style?

1915

How can one find bugs in job sequence?

781

Explain what task is 98% of the required work of a business analyst?

598

Explain what is analytical or analytic mean?

581

Explain fact constellation schema?

564




What are the various kinds of containers available in datastage?

561

why a stop statement is needed for the point= option on a set statement?

623

What is drilling across?

557

How to load last n records of file into target table - informatica

596

Can u access a repository created in previous version of Informatica?

1466

What do you mean by trimming sql in microstrategy?

520

Explain what are fact, dimension, and measure?

550

Explain how many types of dimensions are available in informatica?

590

What are the various types of layout supported by abinitio?

579

what is broad cast agent? : Sas-bi

593

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