 Related Questions 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, ... set of level properties that describe a specific aspect of a business, used for analyzing the factual measures of one or more cubes, which use that dimension. Egs. Geography, time, customer and product. Latest Answer : Dimensions are mainly classified as follows:Conformed dimensionsDegenerate dimensionsJunk dimensionsRole playing dimensionsApart from these types we mainly encounter Slowly changing dimensions which fall mainly under three categories type 1type 2type ... 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 ... Use lookup transformation in u’r mapping to lookup data in a relational table,view,synonym. Informatica server queries the look up table based on the lookup ports in the transformation.It compares Latest Answer : Lookup transformation in a mapping is used to look up data in a flat file or a relational table, view, or synonym. You can import a lookup definition from any flat file or relational database to which both the PowerCenter Client and Server can connect. ... To perform the following tasks. Get a related value. For example, if your source table includes employee ID, but you want to include the employee name in your target table to make your summary data easier Latest Answer : Hi The ans to ur question is YesThere are 2 types of lookups: Dynamic and Normal (which you have termed as Static).To configure, just double click on the lookup transformation and go to properties tabThere'll be an option - dynamic lookup cache. select ... Connected and unconnected Latest Answer : hey, what zaki told was correct.There are only two type: connected and unconnected.Mostly we use cache concept for connected, also only connected lkp will support SOME cache options. ... 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 : 1]. Connected lookup receives input values directly from mapping pipeline whereas UnConnected lookup receives values from: LKP expression from another transformation.2]. Connected lookup can use a dynamic or static cache. Unconnected lookup can ... 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
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
