![]() |
| 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 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 ... Place it in local folder Latest Answer : We can place source file any where in network, but it will consume more time to fetch data from source file, but if the source file is present on server srcfile then it will fetch data from source upto 25 times faster than previous. ... U can not create or import flat file defintion in to warehouse designer directly.Instead U must analyze the file in source analyzer,then drag it into the warehouse designer.When U drag the flat file source Latest Answer : While creating flatfiles manually, we drag and drop the structure from SQ if the structure we need is the same as of source, for this we need to check-in the source and then drag and drop it into the Flatfile, if not all the columns in the source will ... Maplet is a set of transformations that you build in the maplet designer and U can use in multiple mapings. Latest Answer : Basically mapplet is a subset of the mapping in which we can have the information of the each dimension keys by keeping the different mappings created individually. If we want a series of dimension keys in the final fact table we will use mapping designer. ... 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 ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||