ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Informatica
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
how to we create datamart?
 Question Submitted By :: Srinivasarao
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how to we create datamart?
Answer
# 1		 
Datamart is a subset of data warehouse and it supports a 
particular region, business unit or business function. 
Data warehouses and data marts are built on dimensional 
data modeling where fact tables are connected with 
dimension tables. It is designed for a particular line of 
business, such as sales, marketing, or finance.
 
Is This Answer Correct ?    0 Yes 0 No
Vaibhav Bhandeo
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
what happens when a batch fails?  3
How to recover sessions in concurrent batches?  1
what are the reusable tasks in informatica ? IBM4
What are the Differences between connected and unconnected lookup?  1
Why we use lookup transformations?  1
What is the difference between OLTP and ODS?  2
How to merge First Name & Last Name?  2
Explain about HLD and LLD ? Accenture7
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why. CTS3
if the session fails after 100 records agian we have to starts the session or we go for recovery session TCS2
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?  1
What is parameter file?  1
In real time scenario where can we use mapping parameters and variables? CSC3
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance Deloitte11
What is hash partition?  1
Which transformation should u need while using the cobol sources as source defintions?  2
How to recover the standalone session?  2
Define maping and sessions?  3
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?  1
What is aggregate cache in aggregator transforamtion?  2
 
For more Informatica Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com