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

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

IBM, TCS,

3 8805

What is target update override

CTS,

2 7560

How to get part of string form the source string without using sub string function in SAS?

3 7827

Hi , can anybody explain me what is the need of migration ? and how to do it ? could plz explain me in detail?

2 5022

How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.

Satyam,

2 5970

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

HCL,

5 13181

sorce is a flatfile only 1st and last row should insert to target how will u do?

HCL,

2 9100

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

HCL, Schneider,

2 12452

if soource is having 10 records how will u insert 20 records to target

HCL,

6 12288

In session log thier should not be a single error how will u do

HCL,

3 9131

What is an incremental loading? in which situations we will use incremental loading

HCL,

2 9299

what is diff between IN and EXIT commands

HCL, Schneider,

1 7180

what is persistant cache in which situation we will use persistantcache

HCL,

1 6858

Insert else update option in which situation we will use

HCL,

4 11362

what is pre and post sql and what is diff between source presql and target pre sql

HCL, IBM,

1 19524

Un-Answered Questions { Data Warehouse }

Your application mode has crashed. How would you run your i-server?

983

What is the difference between formal and export parameter? Export at what secenario we are going to use?

2643

9. What was the most complex type of report you dealt with?

2218

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1895

What is upsert statement in teradata?

1140

Explain the shared cache and re-cache?

1122

How will you enable or disable caching in the system level and table level?

894

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1289

How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?

4403

How does a rank transform differ from aggregator transform functions max and min?

1208

What are the types of hierarchies?

1025

I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

2074

What is the difference between informatica and datastage?

1231

Explain what is the difference between slice and dice and cross tab report?

1081

What information is provided by .dbc file extension for connecting to the database?

1171

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