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 ...
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 ...
When U add a relational or a flat file source definition to a maping,U need to connect it to a source qualifer transformation.The source qualifier transformation represnets the records that the informatica
Latest Answer : Source Qualifier is a transformation with every source definiton if the source is Relational Database.Source Qualifier fires a Select statement on the source db.With every Source Definition u will get a source qualifier without Source qualifier ...
If u parttion a session with a relational target informatica server creates multiple connections to the target database to write target data concurently.If u partition a session with a file target the
Latest Answer : Could you please tell me how can we partition the session and target? ...
Maplet consists of set of transformations that is reusable.A reusable transformation is a single transformation that can be reusable. If u create a variables or parameters in maplet that can not be used
Latest Answer : Mapplet is a group of reusable transformation.The main purpose of using Mapplet is to hide the logic from end user point of view...It works like a function in C language.We can use it N number of times.Its a reusable object.Reusable transformation ...
The Informatica repository is a relational database that stores information, or metadata, used by the Informatica Server and Client tools. Metadata can include information such as mappings describing how
Latest Answer : Infromatica Repository:The informatica repository is at the center of the informatica suite. You create a set of metadata tables within the repository database that the informatica application and tools access. The informatica client and server access ...
The PowerCenter repository allows you to share metadata across repositories to create a data mart domain. In a data mart domain, you can create a single global repository to store metadata used across
Latest Answer : Standalone repository. A repository that functions individually, unrelated and unconnected to other repositories. Global repository. (PowerCenter only.) The centralized repository in a domain, a group of connected repositories. Each domain can contain ...
How can u work with remote database in informatica?did u work directly by using remote connections?
To work with remote datasource u need to connect it with remote connections.But it is not preferable to work with that remote source directly by using remote connections .Instead u bring that source into
U can Debug U’r maping in maping designer U can view the work space over the entire screen The designer displays a new icon for a invalid mapings in the navigator window U can use a dynamic lookup
In case of storedprocedure transformation procedure will be compiled and executed in a relational data source.U need data base connection to import the stored procedure in to u’r maping.Where as
