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

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

Wipro,

3 9068

in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

Wipro,

2 9661

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

Wipro,

2 6423

what is the different between link and join ?

2 5439

what is requery in cognos?

HMN, Satyam, TCS,

2487

What is APT_DUMP_SCORE?

IBM,

2 19135

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

HP,

8 11089

what is mean by flag 4 in update strategy t/r

6 10874

how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls

Patni,

2 6343

How to publish a package by running Java Script?

2092

how to remove the duplicates by proc sql?

Genpact,

2 9407

How we can convert rows to columns in datastage?

IBM,

4 25103

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 7599

how to delete the duplicates by using proc sql?

Genpact,

3 9050

what is the difference between proc means and proc summary?

Accenture,

2 7673

Un-Answered Questions { Data Warehouse }

What is the reusable transformation?

1053

I have a few records just I want to store data in to targets cycling way how?

2375

What are the different versions of informatica?

1279

Explain data flow graph with an example?

1137

Differentiate between datastage and datastage tx?

1059

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6194

Explain what is partitioning? What are the types of partitioning?

973

What is the difference between aggregate table and materialized view?

1105

How to create a repository in abinitio for stand-alone system(local nt)?

1131

Explain the term 'row' related to relational database management system?

956

Can you define drill down and drill up?

1037

I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

1764

What is the report studio?

1023

How to test report in reportnet?

1017

What are the mapping paramaters and maping variables?

1039

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