Data Warehouse Interview Questions
Questions Answers Views Company eMail

How can we delete duplicate rows from flat files?

901

Differentiate between a database and data warehouse?

830

How we can use union transformation?

763

What do you understand by a term domain?

823

Define joiner transformation?

754

Define enterprise data warehousing?

818

Write the advantages of partitioning a session?

923

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

815

Differentiate between a repository server and a powerhouse?

722

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

745

What are mapplets?

968

What are data-driven sessions?

880

How many numbers of sessions can one group in batches?

763

How many repositories can be created in informatica?

1 1287

Define update strategy?

772


Un-Answered Questions { Data Warehouse }

Highlight a few of the important components of Teradata?

721


What is purpose of having conditionality in metrics in microstrategy?

708


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

2283


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2101


Can you explain the advantage of using shortcuts?

741






Can Bo generates the Report from the cubical data Explain?

1766


What is domain in terms of informatica?

700


What is the main difference between schema in rdbms and schemas in datawarehouse?

705


What are the mapping paramaters and maping variables?

706


my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

1771


How to load specific no.of records using bteq, or fastload,or multiload

1460


what versions of sas have you used (on which platforms)? : Sas programming

745


What are the static cache and dynamic cache in informatica?

904


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

11080


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

804