1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

which r the connectors used in san?

 1778

what is the generated prompt,how can i use?

 5 17989

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

 1791

What is mean by tuning the report?

 1 2446

what are they different types of report in BO?

 6 30360

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

 5 10164

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

 5 25266

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 8443

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 13413

What are set operators in Oracle

Deloitte, Wipro,

3 15773

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 16539

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 33886

why sequence generator should not directly connected to joiner transformation ?

ANZ,

1 9771

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

 1 4348

What is Target Update Override? What is the Use ?

Patni,

8 16745

Un-Answered Questions { Data Warehouse }

Distinguish between cognos dynamic cube and transformer/tm1 cube and powerplay cube?

1

What are the types of caches in lookup? Explain them.

536

What is meant by a domain?

611

How the ipc stage work?

661

What is the use of dimensional modeling in data warehousing?

522




How do you manage the Parameter files while migrating your data from one environment to another environment?

530

What is the difference between proportion and average?

2740

What are the basic requirements to join two sources in a source qualifier transformation using default join?

602

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1744

What are the advantages of informatica?

560

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1829

what are passthrough functions?

484

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

700

Where is teradata rdbms used?

657

What is the role of unrestrictive users? : sas-grid-administration

562

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