Interested to Buy Any Domain ? << Click Here >> for more details...
In aggregator if u enable sorted input what will be the
output and disable sorted wt is output
- 6 Answers
- 12841 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / usha
when ever we r enable sorted input option in aggregator
transformation from source we should get data in sorted
form...
if not session fails
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / amedela chandra sekhar
if u enable sorted input option in aggregator with out group
by result is one row for all input records.
If u enable sorted input and group by session will fail.
| Is This Answer Correct ? | 1 Yes | 0 No |
hi try this senario session will fail
| Is This Answer Correct ? | 0 Yes | 0 No |
session will failed because it accepts only sorted input
| Is This Answer Correct ? | 2 Yes | 6 No |
Answer / suneelkumar.dasari
If u enable the sorted input first of all burden on session will decrease and in sorted order aggregate data will come.
If u disable the sorted input port first first row type aggregate data and second row type aggregate date will come.But session won't fail.
Correct me if i am wrong.
| Is This Answer Correct ? | 2 Yes | 6 No |
explain abt joiner t/r?
Explain sessions and how many types of sessions are there?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is the procedure for creating independent data marts from informatica 7.1?
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
where does the default group roew in a router is stored what is the default size of memory in router
what is materialized view?
What is the difference between Active and Passive transformation?
what is informatica metadata?
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 ??
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
Can you start a batches with in a batch?
Teradata 
