Interested to Buy Any Domain ? << Click Here >> for more details...
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
- 3 Answers
- 8455 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / koti
To do aggr. caliculations function it needs some time.. we
can reduce that time by providing sorted I/P. The time is
less which can takes to forward the rows from sorter to
aggregator rather than the time to do aggr. calculations
without sorted data.....
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / bhupal
if u wont use the sorted input the aggregator transformation will reads the records and keep until all the calculations are done.
if we provided the sorted input it reads the records and release the records reaching next first record of new group.
the integration service will creates the cache for only the sorter keys and only one cache in sorter t/r. so by providing the sorted input we get the performance advantage.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / james
Sorted input in an aggregator transformation does not use
cache instead it uses the memory. Reading from memory is
faster than reading from cache.
| Is This Answer Correct ? | 0 Yes | 1 No |
I have 1200 records how can u send it in aggregator with good performance issues?
how can we calculate fact table size?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
what is correlated query?
Can you start a batches with in a batch?
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
wht is full process of Information source to target just like stg to productuon and development
Plz can any one say me how to get the informatica certification materials and dumps
what is mean by flag 4 in update strategy t/r
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
Teradata 
