 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 : the 2 modas areUnicode modeAscii 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 ... 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 : Thats a good question, suppose say you have 40 transformations in your mapping which invole complex agg, functions, so in middle of the mapping there is a requirement to get the data from some x table, what will you do now? Will you get this as a ... 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 ... 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. ... 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 ... 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 ... 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 : −Normalizer transformations−Cobol sources−XML Source Qualifier transformations−XML sources−Target definitions−Pre- and post- session stored procedures−Other mapplets-PowerMart 3.5-style LOOKUP functions-non reusable ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 
1