What is the difference between Power Centre and Power Mart?
- 5 Answers
- 19249 Views
- TCS, I also Faced
- E-Mail Answers
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 |
What is a standalone command task?
TELL ME ABOUT WORK FLOW SCHEDULING?
have you developed documents in your project? and what documents we develop in realtime?
How can u stop a batch?
SO many times i saw "$PM parser error " .what is meant by PM?
Separate from an archive server and a powerhouse?
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
Could you explain what is enterprise data warehouse?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
Design time, run time. If you don't create parameter what will happen
Teradata 
