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 1658

What are the limitations for memory allocation for SAS variables

Signetsoft,

919

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

Signetsoft,

844

What is maximum storage capability of SAS?

 897

: and & modifiers.

Oracle,

854

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

TCS,

1 14365

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,

1098

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 1928

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 1282

How many Key we can define in remove duplicate stage?

CTS,

811

Un-Answered Questions { Data Warehouse }

What is the difference between teradata and basic rdbms?

558

Syntax for case when statement?

600

What is the use of powerplay web viewer in cognos?

547

What is process model?

1540

Explain your project of banking domian.

1208




Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6742

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

619

What is MPP in Redshift ?

5

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

694

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3750

How to generate the report from excel sheet?

575

What's the difference between timestamp (0) and timestamp (6)?

621

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1916

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1113

What is critical column?

664

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