Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Power Centre and Power Mart?
- 5 Answers
- 21551 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 |
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
what are the unix commands to start the wrk flow ?
What is a joiner transformation and why it is an active one?
Explain direct and indirect flat file loading (source file type) - informatica
How you count the number of records available at your source?
How union transformation is used?
Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
How are indexes created after completing the load process?
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
can we use mapplet as starting n ending object in mapping
Teradata 
