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 to return multiple columes through through un-connect lookup?

DELL,

1 7086

explain one complex mapping with logic? sales project?

Accenture, JPMorgan Chase,

6738

Performance tuning in UNIX for informatica mappings?

CGI, CTC,

2625

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 3126

How to do the error handling of if ur source is flatfiles?

2024

In ur current projectu have done any performance tuning of mappings?

1 4733

In which scenario did you used pushdown optimization?

1 3406

In which scenario did u used Mapping variable?

Cognizant,

1 2789

In Which scenario did u used Incremental loading?

2 6281

Did u used latest transformations of 8.6.0? for what?

1932

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 7692

what is semi-additive fact?where did u used?

2 5532

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 4020

In dimension and fact table? which one holds big data?

2 6566

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

ACS,

3 7926

Un-Answered Questions { Data Warehouse }

What is persistent lookup cache?

1100

What are the important Features of Redshift?

Explain how many ways you create ports?

1081

How do you load first and last records into target table?

1215

8. How much supervision have you typically received in your previous job?

2315

i have one file i saved in csv how can i take these file into framework manager

2128

What are the differences between datamart vs. Reporting cube?

1163

Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

2513

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1312

Explain what is the data type of the surrogate key?

1033

Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?

1023

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2141

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1114

Why teradata is used?

1060

Differentiate between reusable transformation and mapplet.

1147

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