Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Power Centre and Power Mart?
- 5 Answers
- 21271 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 |
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
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.
How i can upload the MainFrame source For Informatica ?
How many repositories can we create in Informatica??
What is a grid in Informatica?
What are the types of data that passes between informatica server and stored procedure?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
who is the best faculty for informatica in hyderabad ameerpet?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
What is an unconnected transformation?
Teradata 
