 Related Questions Target Types are File, Relational and ERP. Latest Answer : Files, Relational, ERP ... Target Options for File Target type are FTP File, Loader and MQ.There are no target options for ERP target typeTarget Options for Relational are Insert, Update (as Update), Update (as Insert), Update Latest Answer : Target option for Flat file,relational file (update ,Insert). ... Can identify existing rows of data using unconnected lookup transformation. Latest Answer : Set a default value in the lookup transformation as '-1' or '-2'. So if the incoming row is present in the target, it will pass the row with the respective column value which is looked upon, or else if the value is not present in the target, ... 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 ... While importing the relational source definition from database, what are the meta data of source U import? Source name Database location Column names Datatypes Key constraints Tags : RDBMS 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 : 1] Add the metadata of source file into Informatica designer using source
analyzer and save source file definition in the repository.2] When we drag
the source file definition into warehouse designer work space, the warehouse
designer creates a ... 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. Latest Answer : Thats not correct. By this definition Update Strategy should be a passive transformation but it is not.So correct answer is that any transformation which can change 1. Number of rows 2. Row type i.e. DD_INSERT, DD_DELETE... 3. Transaction control... All ... 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 ... When a Joiner transformation occurs in a session, the Informatica Server reads all the records from the master source and builds index and data caches based on the master rows. After building the caches, Latest Answer : For version 7.x and above :When the PowerCenter Server processes a Joiner transformation, it reads rows from both sources concurrently and builds the index and data cache based on the master rows. The PowerCenter Server then performs the join based on ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
