Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

why we use stored procedure transformation?

IBM,

4 9064

how to limit number of rows in a report in business objects using webi?

Cap Gemini, TCS,

3 19849

HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com

FIS,

5 11006

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

MGL,

2 7916

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

Infotech,

5 10187

what are the roles and responsibilities of teradata DBA ?

TCS,

1 28136

what are the day to day activities of teradata DBA ?

TCS,

5826

what are the roles and responsibilities of BO Administrator ?

OCS Infotech, TCS, Wipro,

1 23418

what are the day to day activities of BO administrator ?

TCS,

3024

Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please

HCL,

1 11989

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

IBM,

6 30968

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 4322

What is the need of building a data warehouse?

2 4831

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

IBM,

1 4164

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 6520

Un-Answered Questions { Data Warehouse }

Where we use surrogate key explain with example?

1135

what is the use of proc sql? : Sas programming

1133

How many steps etl contains explain with example?

970

Explain the features of connected and unconnected lookup.

935

46.How you can create cross joined output using join component ? 47.What is the default layout of watcher files ? How to use in abinitio graph? 48.Why you get 'too many open files' error ? How to use in abinitio graph? 49.What is the significance of vnode folder under AB_WORK_DIR ? How to use in abinitio graph? 50, What is the significance AB_AIR_BRANCH? How to use in abinitio graph? 51. How can you select only unique records from a set of records ? How to use in abinitio graph? 52. How next_in_sequence work in parallel layout ? How to use in abinitio graph? 53. Why you want to set a modest number in limit ? How to use in abinitio graph? 54. How you can encrypt a password and use it in dbc file? How to use in abinitio graph? 55. Which function you should be using if you do not want to process non printable char from a feed file ? How to use in abinitio graph? 56. How you can run a component for certain conditions ? How to use in abinitio graph? 56. What is catalog and when you should use it ? How to use in abinitio graph? 57. How you can use reformat as a router ? How to use in abinitio graph? 58. How many process gets created for a n-way parallel component ? How to use in abinitio graph? 59. Why delimited DMLs take more time to process than fixed length DMLs? How to use in abinitio graph? 60. How can you select only first and last record from a file without using next_in_sequence? How to use in abinitio graph? 61.Why you should always keep largest input as driving input for Join ? How to use in abinitio graph? 62. What a catalog file contains ? How to use in abinitio graph? 63. What Is private project and public project ? How to use in abinitio graph? 64. Why you should not use checkpoint after replicate ? How

5741

ware house management system is used?

1015

what are the major three types of modeling used?

1067

What is union transformation in informatica?

1146

What is Additive function?

2036

What is a source qualifier?

1109

What are tpump utility limitations?

1124

how many types of viewers available in tm1?

what is the use of materialized view?

1574

Explain and compare pros and cons of start schemas?

1067

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

1011

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