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

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

CSC,

5 18256

All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

iFlex,

2154

what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me

IBM,

4 9026

how can you improve the performance of a query, If it is excuting very slowly?

Zensar,

2 7324

wt is a-z and a--z?

Accenture,

3 8847

how can u join the two tables without using proc sql Joins and nested queries ?

IBM,

6 13610

WHAT IS LAG FUNCTION ? WHERE CAN YOU IMPLEMENT THIS FUNCTION?

IBM, Zensar,

3 13401

HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES? WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?

Accenture, Novartis,

3 10330

CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE

CybAge,

4 8151

Difference between drill by and drill across with example?

TCS, WNS,

4 23962

Un-Answered Questions { Data Warehouse }

What is MPP. Is Redshift support MPP?

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1479

What do you mean by fastexport in teradata?

1056

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1769

How you can fix the truncated data error in datastage?

1903

What are cluster analysis in data warehousing?

1186

What are the types of jobs we have in datastage?

1132

How to generate sequence numbers without using the sequence generator transformation?

1274

Name the types of gateway?

1054

How would you identify a macro variable?

1142

What are the benefits of data analyzing?

1250

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1846

Can I access intelligent cubes without olap services?

1112

In abinitio, what types of parallelism are used?

1133

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2235

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