Data Warehouse Interview Questions
Questions Answers Views Company eMail

generate date / time dimension in informatica

Informatica,

800

What are the tasks that source qualifier perform?

Informatica,

722

Explain lookup transformation is active in informatica

Informatica,

734

what are the Methods For Creating Reusable Transformations?

Informatica,

729

how to load rows into fact table in data warehouse

Informatica,

746

What is an active transformation?

Informatica,

739

What are the main issues while working with flat files as source and as targets ?

Informatica,

746

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

Informatica,

1 1319

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

Informatica,

815

Define Data Warehousing?

Wipro,

825

differentiate between view and materialized view?

IBM,

5

name the window by which you can create your own custom scripts?

IBM,

5

what is the role of skipcheck in tm1?

IBM,

5

define drill through?

IBM,

5

how we can generate cubes in cognos?

IBM,

5


Un-Answered Questions { Data Warehouse }

What are the available primary index types?

802


how to create reports on screech?

2151


What is Discover and Execute in XMLA?

1884


can we override a native sql query within informatica? How do we do it?

743


Under what condition selecting sorted input in aggregator may fail the session?

749






What is microstrategy intelligence server?

652


Where the applications and where

593


What are the different log files in obiee?

598


How many types of sorting methods are available in datastage?

717


Is it possible to apply themes to microstrategy web? How?

562


1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

1787


What is "fatal error/rdbms code 3996" error?

764


What is the method of removing duplicates, without the remove duplicate stage?

678


Informatica settings are available in which file?

685


how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2064