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 6984

explain one complex mapping with logic? sales project?

Accenture, JPMorgan Chase,

6669

Performance tuning in UNIX for informatica mappings?

CGI, CTC,

2568

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 3050

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

1968

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

1 4628

In which scenario did you used pushdown optimization?

1 3316

In which scenario did u used Mapping variable?

Cognizant,

1 2699

In Which scenario did u used Incremental loading?

2 6187

Did u used latest transformations of 8.6.0? for what?

1882

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

1 7600

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

2 5401

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 3947

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

2 6458

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 7793

Un-Answered Questions { Data Warehouse }

Explain what is a cube in data warehousing concept?

985

What do you understand by the term 'aggregate advisor?'

963

What is tracing level and what are the types?

958

How can you clear the cache?

1013

Explian the Process of deployment groups in informatica

1062

In which transformation you cannot drag ports into it?

1320

Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1951

What is the syntax for case when statement?

1143

what are the production issues in datastage?

10420

I'm busy writing a report that's using report bursting, to be able to do this I need to use a sequential section. Using a sequential section cause the grouping of the original report not to work. Please can someone give me advise on how to come past this problem, the report need to use grouping as it depend largely on totals ect, and I need to use a sequential section within the report to be able to use the report bursting facility.

2776

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7242

what are the all possible features supported modify stage?

2137

How can we improve the performance in datastage?

1104

Explain sessions. Explain how batches are used to combine executions?

1033

what is business intelligence? : Sas-bi

1068

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