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 ??
Answers were Sorted based on User's Feedback
Answer / guest
Typo error in my previous post.
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 Aggregation Transformation is sorted.
Regards,
Kumar
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / 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 |
Which will beter perform IIf or decode?
How Union Transformation is an Active Trans?
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
What are the conditions needed to improve the performance of informatica aggregator transformation?
how can import the data from the flat files?
What is a configuration management?
What is sorter transformation?
what is row level and column level indicator?
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
what is size of u r database?
State the limitations where we cannot use joiner in the mapping pipeline?