We can achieve better perfomance using sorter before an
aggragator. Then what is the significance of 'Sorted Input'
check in aggregator ?? Please let me know the difference ??
- 2 Answers
- 5539 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
Integration service is not intelligent enough to know the
data is sorted. So If "Sorted Input" Option is checked,
then Integration service understands that the input data to
the sorter Transformation is sorted.
Regards,
Kumar
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Describe the impact of several join conditions and join order in a joiner transformation?
Why do you use Mapping Parameter and mapping variable?
Briefly explain the aggregator transformation?
What does role playing dimension mean?
How to implement security measures using repository manager?
During the running session, output files are created by informatica server. Enlist few of them.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How to join three sources using joiner? Explain though mapping flow.
What is flashback table ? Advance thanks
Separate from a database, an information bazaar, and an information stockroom?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Why is sorter an active transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
How to generate or load values in to the target table based on a column value using informatica etl tool.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
