Comment posted by: Deb on 2005-06-08 00:56:53Ans: While running a Workflow,the PowerCenter Server uses the Load Manager process and the Data Transformation Manager Process (DTM) to run the workflow and
Latest Answer : I am providing the answer which I have taken it from Informatica 7.1.1 manual, Ans: While running a Workflow,the PowerCenter Server uses the Load Manager process and the Data Transformation Manager Process (DTM) to run the workflow and carry ...
Reusable transformations can be used in multiple mappings.When u need to incorporate this transformation into maping,U add an instance of it to maping.Later if U change the definition of the transformation
Latest Answer : 1. A reusable transformation can be used in multiple transformations2.The designer stores each reusable transformation as metada separate from any mappings that use the transformation.3. Every reusable transformation falls within a category ...
Maping parameter represents a constant value that U can define before running a session.A mapping parameter retains the same value throughout the entire session. When u use the maping parameter ,U declare
Latest Answer : Mapping parameter represents a constant value defined before mapping run.
Mapping reusability can be achieved by using mapping parameters.
Mapping variable represents a value that can be changed during the mapping run.
Mapping variable can be used ...
NO. We can use mapping parameters or variables in any transformation of the same maping or mapplet in which U have created maping parameters or variables.
Latest Answer : The scope of a mapping variable is the mapping in which it is defined. A variable Var1 defined in mapping Map1 can only be used in Map1. You cannot use it in another mapping say Map2. ...
Can u use the maping parameters or variables created in one maping into any other reusable transformation?
Yes.Because reusable tranformation is not contained with any maplet or maping.
U can use command line arguments for a session or batch.This allows U to change the values of session parameters,and mapping parameters and maping variables. Parallel data processing: This feature is available
Parameter file is to define the values for parameters and variables used in a session.A parameter file is a file created by text editor such as word pad or notepad. U can define the following values in
Latest Answer : When you start a workflow, you can optionally enter the directory and name of a parameter file. The Informatica Server runs the workflow using the parameters in the file you specify. For UNIX shell users, enclose the parameter file name in single quotes: ...
Maplet consists of set of transformations that is reusable.A reusable transformation is a single transformation that can be reusable. If u create a variables or parameters in maplet that can not be used
Latest Answer : Mapplet is a group of reusable transformation.The main purpose of using Mapplet is to hide the logic from end user point of view...It works like a function in C language.We can use it N number of times.Its a reusable object.Reusable transformation ...
How can u work with remote database in informatica?did u work directly by using remote connections?
To work with remote datasource u need to connect it with remote connections.But it is not preferable to work with that remote source directly by using remote connections .Instead u bring that source into
U can Debug U’r maping in maping designer U can view the work space over the entire screen The designer displays a new icon for a invalid mapings in the navigator window U can use a dynamic lookup
