|
| 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 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 : 2 ways:1) Using an unconnected lookup and calling the same from an expression. based on the output, the particular set of rows can be filtered out and not be a part of target load data, by putting a filter right after the expression.2) using a connected ... 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 : Look up tranformations are used toGet a related valueUpdating slowly changing dimensionCaluculating expressions ... 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 : 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 ... 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
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
