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 want skip first 5 rows to load in to target? what will be the logic at session level ??

IBM,

1 7086

Demonstrate experience in maintaining quality process standards?

iGate,

2554

How to get the repeated values by using sql in sas ?

2 5664

What is factless fact schema?

3 7252

Difference between Teradata V2R5 and Teradata V12 versions?

IBM,

2 8435

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

IBM, TCS,

7 10866

Hi, How to navigate one report to another report in webi? Thanks in Advance

3 8636

How do you eliminate duplicates?

3 8114

how can u find out the datastage job is running on how many nodes

IBM,

7 23081

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.

Quintiles,

9 13062

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 4264

can you apply grouping on crosstab?

CTS,

1 6768

if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?

CTS,

2 8805

how to convert crosstab into list?

TCS,

4 9874

data import to models, datastores,stored processed, is there any other way to import data?

TCS,

1 4292

Un-Answered Questions { Data Warehouse }

Explain what are the various methods of getting incremental records or delta records from the source systems?

967

List some pros and cons of amazon redshift?

explain the use of % includes a statement in sas? : Sas-administrator

1006

What is a real-time data warehouse?

998

Difference between inner join and outer join?

1028

What is the difference between absolute filtering and standard filtering?

1052

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2500

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2867

What is VLDB?

1059

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

2213

Mention what is the syntax for m_dump in abinitio?

1475

Explain the teradata primary index mechanics in detail with a diagram.

978

What is an olap designer?

968

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

986

Explain what are the different types of data warehousing?

963

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