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.

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

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.

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.

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

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

7 Answers   Deloitte,

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

What is rank transform?

0 Answers  

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,

How to elaborate tracing level?

0 Answers  

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

What are the different components of powercenter?

0 Answers  

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,

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.

0 Answers  

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  

What are the active and passive transforamtions?

2 Answers