What r the active and passive transforamtions?

An active transforamtion can change the number of rows that pass through it.A passive transformation does not change the number of rows that pass through it.


What r the reusable transforamtions?

need to incorporate this transformation into maping,U add an instance of it to maping.Later if U change the definition of the transformation ,all instances of it inherit the changes.Since the instance of reusable transforamation is a pointer to that transforamtion,U can change the transforamation in the transformation developer,its instances automatically reflect these changes.This feature can save U great deal of work.


How many ways u create ports?

Two ways
1.Drag the port from another transforamtion
2.Click the add buttion on the ports tab.


What r the methods for creating reusable transforamtions?

Two methods
1.Design it in the transformation developer.
2.Promote a standard transformation from the mapping designer.After U add a transformation to the mapping , U can promote it to the status of reusable transformation.
Once U promote a standard transformation to reusable status,U can demote it to a standard transformation at any time.
If u change the properties of a reusable transformation in mapping,U can revert it to the original reusable transformation properties by clicking the revert button.


What r the unsupported repository objects for a mapplet?

Source definitions. Definitions of database objects (tables, views, synonyms) or files that provide source data.

  Target definitions. Definitions of database objects or files that contain the target data.

  Multi-dimensional metadata. Target definitions that are configured as cubes and dimensions.

  Mappings. A set of source and target definitions along with transformations containing business logic that you build into the transformation. These are the instructions that the Informatica Server uses to transform and move data.

  Reusable transformations. Transformations that you can use in multiple mappings.

  Mapplets. A set of transformations that you can use in multiple mappings.

  Sessions and workflows. Sessions and workflows store information about how and when the Informatica Server moves data. A workflow is a set of instructions that describes how and when to run tasks related to extracting, transforming, and loading data. A session is a type of task that you can put in a workflow. Each session corresponds to a single mapping.