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

how can we use sorter transformation in joins?

IBM,

5 18182

Can any one expalain the procedure for How to create a Mastr Detail Report in Cognos 8.3 ver?

1 4428

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2413

What are symbol tables?Differemce between Local N Global Symbol tables.....

TCS,

2 10558

In which format does Date stores in sas..? What is the use of DATE in SAS.?

TCS,

3 9718

One way of creating a new variable in Macros is by % Let....What is the other way..?

TCS,

5 11137

What are the functions done while Compilation...?

TCS,

1 6401

What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?

TCS,

3 9310

What is difference between Global n Local Macro Variables..?

TCS,

6 28265

What is Transaction...? And what are Comment, Roll back n Save point..?

2 7064

Explain the Difference Between Bursting and Scheduling?

1 18021

any body can say about all versions of informatica ?how many versions ?

2 10088

if ename='subbu' while running job the job should be abort how come?

IBM,

3 8849

how to find diff between 2 dates without using Icon... funtions?

1 3748

how to find no.of records in sequntial file itself?

4 21859

Un-Answered Questions { Data Warehouse }

Name the different types of Lookups in Datastage?

1316

What is the difference between look-up file and look-up, with a relevant example?

1255

How an expression transformation differs from aggregator transformation?

1095

What are the various types of transformation?

1249

What are the functionalities of link partitioner and link collector?

1070

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2079

explain checkin and checkout?

1198

Mention what are the data types does SAS contain?

1198

How far Redshift is better in performance as compare to other data warehouse technologies?

what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?

997

Triggers,VIEW,Procedures

1271

What is data modeling and data mining?

1033

What happens when we provide null key to sort, merge and pbks in Abinitio ?

1759

What is microstrategy desktop?

1082

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

4260

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