Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Power Centre and Power Mart?
- 5 Answers
- 21739 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 aggregate cache in aggregator transforamtion?
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
Please let me know how to make encryption and decryption with example?
What is depict expression change?
without update strategy how to insert &update?
What is a rank transform?
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
What is a node in Informatica?
How can we use mapping variables in informatica?
what is the difference between onsite & client site?
What all are steps in up gradation of Informatica server?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
Teradata 
