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 ...
Session - A Session Is A set of instructions that tells the Informatica Server How And When To Move Data From Sources To Targets. After creating the session, we can use either the server manager or the
Latest Answer : Session is a set of instructions that relates to extraction, transformation and loading. Session is a task that relates to data acquisition.
There are two types of taskReusable taskNon reusable taskBatch :Batch is a group of sessions, There are three ...
Mapping designer Tansformation developer Mapplet designer
Latest Answer : Mapping DesignerMaplet DesignerTransformation Deveoper - for reusable transformation ...
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 ...
COBOL source definition Joiner transformations Normalizer transformations Non reusable sequence generator transformations. Pre or post session stored procedures Target defintions Power mart 3.5 style Look
Latest Answer : normaliser, xml source qualifier and cobol sources cannot be used ...
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 ...
Connected lookupUnconnected lookup Receives input values diectly from the pipe line.Receives input values from the result of a lkp expression in a another transformation.U can use a dynamic or static
Latest Answer : Hi Differences Between Connected and Unconnected LookupsConnected LookupUnconnected LookupReceives input values directly from the pipeline.Receives input values from the result of a :LKP expression in another transformation.You can use a dynamic ...
Static cache Dynamic cache U can not insert or update the cacheU can insert rows into the cache as u pass to the target The informatic server returns a value from the lookup table or cache when the condition
Latest Answer : lets say for example your lookup table is your target table. So when you create the Lookup selecting the dynamic cache what It does is it will lookup values and if there is no match it will insert the row in both the target and the lookup cache (hence ...
Normalizer Transformation. When U drag the COBOL source in to the mapping Designer workspace,the normalizer transformation automatically appears,creating input and output ports for every column in the
Latest Answer : The Normalizer transformation normalizes records from COBOL and relational sources, allowing you to organize the data according to your own needs. A Normalizer transformation can appear anywhere in a data flow when you normalize a relational source. Use ...
A Router transformation is similar to a Filter transformation because both transformations allow you to use a condition to test data. However, a Filter transformation tests data for one condition and drops
Latest Answer : Note:- i think the definition and purpose of Router transformation define by sithusithu, sithu is not clear and not fully correct as they of have mentioned sorry sithu and sithusithubut ...