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

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 6357

Hi, If anyone has base SAS certification dumps, please share.

1868

A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.

IBM,

3 7676

What is the difference between Link collector and Funnel Stages?

1 7218

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

HCL,

1 4598

Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.

1 2779

how teradata fetches a row from primary index table?

1 3738

tell me about use of arrays in sas

CoreEL,

1 4384

How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

HCL,

2057

count number of deptno in a emp table?

IBM,

2 5419

deptno wise to find max and min,and sum of rows and in target to company wise maximum

IBM, TCS,

1 4795

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

Deloitte, IBM,

3 10190

input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?

HSBC,

2 6419

what is flow of project?

HSBC, IBM,

2002

explain about citrix scheduling tool in datastage

HSBC,

2457

Un-Answered Questions { Data Warehouse }

Define APT_CONFIG in Datastage?

1081

what are the benefits of data integration? : Sas-di

1108

What are the different table types supported by teradata?

969

What is the information present in the cognos configuration file?

959

What is size of a transaction and an array means in a datastage?

1315

Can you connect multiload from ab initio?

1217

Explain what are the advantages and disadvantages of reporting directly against the database?

1003

Explain the features of connected and unconnected lookup.

935

what is the way of writing a feeder statement when feeding one cube from another?

What is the need of an ETL tool?

1101

what is guided navigation?

901

What do you understand by active and passive transformations?

942

What is a dimension?

1033

What is the function of surrogate key in data warehousing?

1066

What is abinitio?

1175

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