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

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

0 Answers   SeeInfoBiz, TCS,

how tokens will generate?

0 Answers  

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

What are the parts of Informatica Server?

1 Answers   Cognizant,

How will you combine 3 different sources with a single source?

3 Answers  

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

When to use normalization transformation other than cobol source?

2 Answers