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
- 8477 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define mapplet?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What the difference is between a database, a data warehouse and a data mart?
What is dimensional table? Explain the different dimensions.
Mention few power centre client applications with their basic purpose?
explain one complex mapping with logic? sales project?
What is the difference between stop and abort in informatica
Why sorter is an active transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What do you understand by term role-playing dimension?
How do you update the records with or without using update strategy?
expain about the tune parameters?
Explain scd type 3 through mapping.
