Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6310 Views
- I also Faced
- E-Mail Answers
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 |
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
What is the Difference between SetVariable and setmaxvariable in informatica?
In informatics server which files are created during the session rums?
Describe an informatica powercenter?
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
What is intricate mapping?
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
What is metadata reporter?
What is standalone command task?
why we use source qualifier transformation?
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
Teradata 
