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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is granularity? Please explain with example

IBM,

1 1307

Explain me ETL project architecture in Detail?

Infosys,

1914

How to load a Dimension ? and how to load a fact table?

 941

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

Wipro,

1 1649

What are the limitations for memory allocation for SAS variables

Signetsoft,

915

What is maximum number of rows and cols can be handled in SAS?

Signetsoft,

838

What is maximum storage capability of SAS?

 895

: and & modifiers.

Oracle,

854

Describe step by step the process of creating tag and savefile for migration

TCS,

1 14310

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

 1024

Target increases every day even though no new record was inserted

Accenture,

1095

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

Virtusa,

1 1924

how to run a sequential file stage in parallel if the stage is used on the TARGET side

Virtusa,

1123

Which is the best place to learn Informatica Powercenter Online Training?

 1 1280

How many Key we can define in remove duplicate stage?

CTS,

811

Un-Answered Questions { Data Warehouse }

explain about balanced dimension,

554

Differentiate between hash file and sequential file?

569

What formatting can be applied to the information that is sent out by microstrategy narrowcast server?

556

What are some different alternative commands associated with "dsjob"?

639

What is the function of aggregator transformation?

566




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

1537

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?

587

How to hide certain columns from a user?

498

my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

1647

What are the prime responsibilities of data integration administrator? : Sas-di

578

difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

2294

Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

550

Do you know how to prioritize the excecution of a report?

538

What is the differnce between SDTM 3.1.2 to 3.1.1 version

4590

How to convert RGB Value to Hexadecimal values in datastage?

3442

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