 Related Questions The data movement mode depends on whether Informatica Server should process single byte or multi-byte character data. This mode selection can affect the enforcement of code page relationships and code Latest Answer : There are 2 modes of data moment:1. Normal mode2. Bulk modeNormally if there are no data constraints (key constraints) we will use bulk mode otherwise we use normal mode. ... Compatibility between code pages is used for accurate data movement when the Informatica Sever runs in the Unicode data movement mode. If the code pages are identical, then there will not be any data 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 ... 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 ... 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 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 ... 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 ... 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 ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
