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
- 8289 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 |
What is the difference between a shortcut of an object and copy of an object? Compare them.
can we see default group,when we use router?if yes how?
What are the transformations that are not supported in mapplet?
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
Implementation methodology
What is difference between partioning of relatonal target and partitioning of file targets?
What are the tuning techniques you applied during your last project
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
what is INFORMATICA TESTING process
Can we use the mapping parameters or variables created in one mapping into another mapping?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
What is log file,and where is it located,why u r using the log file
Teradata 
