|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions 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 ... The aggregator stores data in the aggregate cache until it completes aggregate calculations.When u run a session that uses an aggregator transformation,the informatica server creates index and data caches Latest Answer : when server runs the session with aggregate transformation ,it stores data in memory until it completes the aggregation when u partition a source ,the server creates one memory cache and one disk cache for each partition .it routes the data from one ... U can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation. U need matching keys to join two relational sources in source qualifier transformation.Where Latest Answer : source qualifier is used for reading the data from the database where as joiner transformation is used for joining two data tables.source qualifier can also be used to join two tables but the condition is that both the table should be from relational ... Both pipelines begin with the same original data source. Both input pipelines originate from the same Source Qualifier transformation. Both input pipelines originate from the same Normalizer transformation. Latest Answer : We cannot use joiner transformation in the following two conditions:-1. When our data comes through Update Strategy transformation, or in other words after Update strategy we cannot add joiner transformation2. We cannot connect a Sequence Generator transformation ... Master and detail source Type of join Condition of the join Latest Answer : Master and detail source Type of join Condition of the join the Joiner transformation supports the following join types, which you set in the Properties tab: Normal (Default) Master Outer Detail Outer Full OuterCheers,Sithu ... Normal (Default) Master outer Detail outer Full outer Latest Answer : follw thisIn the Mapping Designer, choose Transformation-Create. Select the Joiner transformation. Enter a name, click OK. The naming convention for Joiner transformations is JNR_TransformationName. Enter a description for the transformation. This description ... 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 ... 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 ... The informatica server builds a cache in memory when it processes the first row af a data in a cached look up transformation.It allocates memory for the cache based on the amount u configure in the transformation Latest Answer : A LookUP Cache is a Temporary Memory Area which is Created by the Informatica Server. which stores the Lookup data based on certain Conditions. The Caches are of Three types 1) Persistent 2) Dynamic 3) Static and 4) Shared ... Persistent cache: U can save the lookup cache files and reuse them the next time the informatica server processes a lookup transformation configured to use the cache. Recache from database: If the persistent Latest Answer : There are five types of caches such as static cache,dynamic cache,persistant cache,shared cache, etc... ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
