Data Warehouse Interview Questions
Questions Answers Views Company eMail

which r the connectors used in san?

1790

what is the generated prompt,how can i use?

5 18041

how much memory space occupied real time project (roughly)?

1801

What is mean by tuning the report?

1 2479

what are they different types of report in BO?

6 30418

How do scheduling the report in BO XIR2? can you say what are they steps?

5 10217

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 25330

I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!

3 8469

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

BirlaSoft,

5 13452

What are set operators in Oracle

Deloitte, Wipro,

3 15825

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

Deloitte,

9 16641

from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

Deloitte,

21 34089

why sequence generator should not directly connected to joiner transformation ?

ANZ,

1 9800

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 4381

What is Target Update Override? What is the Use ?

Patni,

8 16856


Un-Answered Questions { Data Warehouse }

What is decode in static cache?

596


how you can enable bulk load mode in ti?

5


I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?

1613


What is domain in terms of informatica?

564


what is the use of materialized view?

964






What will be the approach?

581


Explain in detail about type 2(scd),

596


Diff b/w Crossproduct and Outerjoin?

1813


What are the benefits of datastage?

725


What is called cognos reporting tool?

600


What is orabulk stage?

634


How can I run the 2 gui merge files?

698


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1855


What do you know about abinitio?

763


What are the different ways to implement parallel processing in informatica?

865