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 have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?

IBM,

2 8339

What is Additive function?

IBM,

2038

Is it possible to create drill through access to other report from PDF report?

IBM,

1 3455

What is Online View?

IBM,

1967

What is Star schema group?

IBM,

1 9645

How to move reports one server to another server?

Wipro,

2 9409

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 7333

How union transformation is active ?

Puma,

2 5936

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

Puma,

7 10621

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

Cap Gemini, Puma, Wipro,

3 10618

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

Puma,

5 8982

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

Puma,

2078

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

Puma,

2187

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

Puma,

2 6857

What is flashback table ? Advance thanks

Puma,

1945

Un-Answered Questions { Data Warehouse }

What are the advantages of cold fusion?

956

How will you monitor the errors received while running i-server and report?

951

How to clean the datastage repository?

1128

After the complete generation of a report who will test the report and who will analyze it?

984

What are stage variables, derivations and constants?

1233

What is the use of stored procedures in teradata?

1011

What you mean by drill across and what is the difference between drill through, drill across?

1029

Is it possible to revert a global repository to local one and why?

1086

what are the devoleper roles in real time? plz tell i am new to datastage....

2164

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1110

How is union transformation utilized?

1016

what is 'reconsideration error' and how can i respond to this error and how to debug this

2634

what do you mean by passthrough functions?

973

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

2974

What olap capabilities do I have within a microstrategy report services document?

927

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