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

can we perform checkin and checkout through sandbox?

1230

What is data mapping and data modelling?

1615

What is the difference between check point and phase?

1381

What is MAX CORE of a component?

1371

What are the operations that support avoiding duplicate record?

1492

What are the Types of parallelism in detail?

1196

State the working process of decimal_strip function?

2213

What is the function that transfers a string into a decimal?

1201

How do you add default rules in transformer?

1274

How do you improve the performance of a graph?

1213

Explain PDL with an example?

1370

State the first_defined function with an example?

1 8054

What are the Graph parameter?

1205

What is the function you would use to transfer a string into a decimal?

1284

explain checkin and checkout?

1198

Un-Answered Questions { Data Warehouse }

What is full load & incremental or refresh load?

1250

what are 3 tech challenges/ common issues you face?

2397

List out all forms of LOCKS that are available in Teradata.

1011

What are normalization, first normal form, second normal form and third normal form?

1118

can u any challenge your project?

2085

What do you mean by inmon?

1137

What are the restrictions of union transformation?

1090

How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

1411

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

830

how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio

2186

what are factless facts? And in which scenario will you use such kinds of fact tables.

1863

Why do we use link partitioner and link collector in datastage?

1195

What is sequence generator transformation in informatica?

1127

How many types of facts and what are they?

1066

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1083

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