|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Can identify existing rows of data using unconnected lookup transformation. Latest Answer : 2 ways:1) Using an unconnected lookup and calling the same from an expression. based on the output, the particular set of rows can be filtered out and not be a part of target load data, by putting a filter right after the expression.2) using a connected ... Code Page is used to identify characters that might be in different languages. If you are importing Japanese data into mapping, u must select the Japanese code page of source data. 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 ... After the load manager performs validations for the session, it creates the DTM process. The DTM process is the second process associated with the session run. The primary purpose of the DTM process is Latest Answer : Load manager and DTM are the components of Informatica server. Load manager manages the load on the server by maintaining a queue of sessions and release the session based on first come and first serve. When the session is released from the load ... Lookup Transformations can access data from relational tables that are not sources in mapping. With Lookup transformation, we can accomplish the following tasks:Get a related value-Get the Employee Name Latest Answer : Look up tranformations are used toGet a related valueUpdating slowly changing dimensionCaluculating expressions ... Mapping designer Tansformation developer Mapplet designer Latest Answer : Mapping DesignerMaplet DesignerTransformation Deveoper - for reusable transformation ... An unconnected transforamtion is not connected to other transformations in the mapping.Connected transforamation is connected to other transforamtions in the mapping. Latest Answer : Connect Transformation :A transformation which participates in the mapping data flow Connected
transformation can receive multiple inputs and provides multiple outputsUnconnected :
A unconnected transformation does not participate in the mapping ... 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 Latest Answer : You can design using 2 methodsusing transformation developercreate normal one and promote it to reusable CheersSithu ... 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. ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
