The difference between Oracle Sequence Generator and Informatica Sequence Generator?Which is faster in performance?Which is best to use?
What is the impact of turning versioning on or off for an Informatica repository? What is the impact of versioning on an existing repository and the new repository, when adding a new repository to the repository server?Thanks, Deborah
In lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i am using five connected lookup in mapping that time what happens?
Latest Answer : Dynamic cache - can be configured as connected lookup only. It does not support lookup on flat file. Can have only equality operator in lookup condition.Static cache - can be configured as connected as well as unconnected lookup. Supports lookup on flatfile. ...
Latest Answer : Essbase is a multidimensional DBMS and Hyperion performance suite is a set of BI tools. ...
Latest Answer : optimizing the session performance is known as performance tuning.the session runs in the availabale load window for the informatica server.performance tuning can be achieved in so many ways.1.use the datamovement modes of infomratcia server as ASCII ...
Latest Answer : flatfile is only a permanent store age device means it flow only read processbut dynamic cache is used for read and wirte process so in a flat file u cannot use a dynamic cache in flatfiles ...
What is the difference between using Joiner and Using Lookup to join to tables. Which is good to use.
Can any one explain about the new port that is created in the lookup after enabling the dynamic lookup cache?and what is the associate port??????thanks in advance for your time
Hi ..can any one explain me the performance issues faced in real time ...any real time scenarios would be great...thanks in advance.