 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, ... 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 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 ... 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... ... 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 ... This transformation is used to maintain the history data or just most recent changes in to target table. Latest Answer : Update strategy transformation is used for flagging the records for insert,
update, delete and reject
In Informatica power center u can develop update strategy at two levels
use update strategy T/R in the mapping design
target table options in the ... Insert Delete Update Update as update Update as insert Update esle insert Truncate table Latest Answer : Update as Insert:This option specified all the update records from source to be flagged as inserts in the target. In other words, instead of updating the records in the target they are inserted as new records.Update else Insert:This option enables informatica ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
