How can yoU improve session performance in aggregator
transformation?
Answer Posted / dilip
if you sort the input yet do not select the sorted input
option, the aggregator treats the data as unsorted data &
performs the task hence its cache size increases. the
performance is degraded despite using a sorter.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are different types of transformations available in informatica?
How to join three sources using joiner? Explain though mapping flow.
Explain the features of connected and unconnected lookup.
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is native users?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is repository manager?
Differentiate between source qualifier and filter transformation?
What are the components of the workflow manager?
What are the different lookup cache(s)?
can we override a native sql query within informatica? How do we do it?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How do you manage the Parameter files while migrating your data from one environment to another environment?
Is there any way to read the ms excel datas directly into informatica?