In which situation do we use update strategy?
Latest Answer: Its always performance friendly to use Update strategy than informatica "Update else Insert" session target property. ...
In which situation do we use unconnected lookup?
Latest Answer: Unconnected lookup should be used when we need to call same lookup multiple times in one mapping. For example, in a parent child relationship you need to pass mutiple child id's to get respective parent id's.One can argue that this can ...
What are the possible dependency problems while running session?
Latest Answer: hey, quation is not clear, any how,,Dependency for workflow will always be (sessions and mappings)session will always be (mappings) mappings will always be (transformations) ...
How do you handle error logic in Informatica? What are the transformations that you used while handling errors? How did you reload those error records in target?
Latest Answer: After validating the incoming source data, if we find any invalid data(eg: data not present the dimension table, null data, or difference in the data format) then it can be loaded to a reject table(include one remark column which will help us to identify ...
How & Where will you can see data loading in targets dynamically?
Latest Answer: We can check the target recorded loaded dynamically by validating the query on target records with time period.1) We need to run the target records related query for first load with time period and find the record count of data, any duplicate records ...
What happens if you turn off version?
Latest Answer: You would not be able to track the changes done to the respective mappings/sessions/workflows. ...
Why sequence generator is not directly connected to joiner transformation?
Latest Answer: Sequence generator transformation is basically used to generate a unique number for each record which is updated or inserted in the target table. Also it is used if we want to create a unique key in the table and on the basis of this unique key we are ...
What are the caches available in Joiner transformation?What is stored in Joiner cache(data cache) and Index cache?
Latest Answer: Joiner Transformation cache are consists four types. there persisted cache,static cache,dynamic cache and sharing cache.The Informatica server stores the conditional values in index cache or joiner cache and output values are stored in data cache. ...
What is DTM buffer size, Default buffer blocksize. If any performance issue happens to session, which one we have to increase and which one we have decrease.
Latest Answer: DTM buffer size is memory you allocate to DTM process (12 MB)Buffer Block size is Size of heaviest Source/Target* number of rows that can be moved at a time(should be minimum 20 (64 KB)And Informatica bydeault assign it to be as for 83 sources and Targets(Buffer ...
What is the difference between $ & $$ in mapping or parameter file? In which cases they are generally used?
Latest Answer: $ - is used to denote Server level Variables/Parameters. $$ - is used to denote Mapping level Variable/Parameter. This is the convention that we generally follow to differentiate between Server Level/Mapping Level variables or parameters. Thus anything ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
