What is the difference between Power Centre and Power Mart?
Answers were Sorted based on User's Feedback
Answer / mubbasir
Informatica PowerCenter - has all options, including
distributed metadata, ability to organize repositories into
a data mart domain and share metadata accross
repositories,Partioning is available.
Informatica PowerMart - a limited license (all features
except distributed metadata and multiple registered
servers). No Partioning is available.
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / giri
Power Center Power Mart
------------ -----------
1.Local and Global Local Repository
Repository
2.Session Partition available Session Partition Not
available
3.24 transformation available 16 transformation available
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / pradeep
All native source connectivities to systems such as
mainframe legacy, ERP, EAI only available with PowerCenter
while PowerMart can source from ralational and flat file
sources only.
You will also find design features to handle very large
volumes only available in PowerCenter.
On the repository side only PowerCenter can support the
Global Repository and networked repositories. All other ETL
capabilities and transformation features are the same.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / santhosh kumar n
powercentre powermart
---------------------------------------------------------
1)it is recommended to process 1) it is recommended to
process low volumesof
high volumes of data data
2)it can connect to ERP sources 2)it doesn,t support ERP
sources
such as SAP to perform extraction
3)it can upgrade from local to global(3)it doesn,t support
repository.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / siva prasad
Both power centre and power mart can perform ETL task but
the difference in between them is
In power centre mapping is done
In power mart both mapping and mapplet is done
| Is This Answer Correct ? | 2 Yes | 26 No |
How big was your fact table
What is the need of building a data warehouse?
what are the differences between powercenter 8.1 and powercenter 8.5?
When will you use SQL override in a lookup transformation?
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
What is enterprise data warehousing?
How can one identify whether mapping is correct or not without connecting session?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
what are the settiings that u use to cofigure the joiner transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.