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 you connect eme to abinitio server?

1 4525

What is a partition and what are the different types of partition components in abinitio?

1313

What information does a .dbc file extension provides to connect to the database?

1294

What is sandbox?

1261

Explain how you can run a graph infinitely in ab initio?

1169

What is the difference between partitioning with key / hash and round robin?

1483

What is de-partition in abinitio?

1421

What is rollup component?

1315

What is sort component in abinitio?

1283

What is a rollup component? Explain about it.

1225

How to add default rules in transformer?

1271

Define query studio?

1048

What is main difference mapplets and mapping?

1278

Define metrics studio?

1082

What are the types of studio?

1204

Un-Answered Questions { Data Warehouse }

What are the two types of framework manager?

1439

What are the design methods of data warehousing?

1007

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

1042

How many types of facts and what are they?

1064

Define ramp limit in ab initio?

1326

Can you explain link buffering?

1225

How do you remove duplicate records in informatica? And how many ways are there to do it?

1209

What is vdl (view definition language) explain?

1106

How do you add a number to a macro variable? : sas-macro

1057

What are the data movement modes in informatica?

1214

can be used COM component in Informatica ?

2114

What is a datastage job?

1059

What is a sorter transformation?

1160

define over feeding?

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

3022

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