if we r using aggregator we enabled sorted input but the records r not sorted

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

if we r using aggregator we enabled sorted input but the
records r not sorted what happen?

Question Posted / srinivasarao

7 Answers
22652 Views
HSBC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

if we r using aggregator we enabled sorted input but the records r not sorted what happen?..

Answer / purnima

The session fails.

Is This Answer Correct ?

30 Yes

6 No

if we r using aggregator we enabled sorted input but the records r not sorted what happen?..

Answer / deepthi

If u enable the 'sorted I/p'option in AGG tranformation,
power center server assumes that all data is sorted by
group.
If u use sorted i/p and dont use the sorted data session
fails.

Is This Answer Correct ?

17 Yes

2 No

if we r using aggregator we enabled sorted input but the records r not sorted what happen?..

Answer / infa developer

Session fails

Is This Answer Correct ?

8 Yes

2 No

if we r using aggregator we enabled sorted input but the records r not sorted what happen?..

Answer / krishnakanth.ch

When the 'Sorted Input' is enabled and if the data is not
sorted, then unexpected results will occur. It means the
session will succeed but the end result may not be the way
as per the business requirement.

Another point to be remembered is:

Group by columns in the Aggregator transformation must be
in the same order as they appear in the Sorter
transformation

Is This Answer Correct ?

3 Yes

3 No

if we r using aggregator we enabled sorted input but the records r not sorted what happen?..

Answer / saradhi

i think its thorws an error

Is This Answer Correct ?

2 Yes

4 No

if we r using aggregator we enabled sorted input but the records r not sorted what happen?..

Answer / vaibhav bhandeo

This technique is used when you want a performnce boost.
There will be an aggrigator cache created and will be
indexed. Although you have not given a sorted input it will
still work fine as it is indexed in cache. Please note this
is not like a page fault where you have to bring the page
from the secondary memory when not found in primary memory.

Is This Answer Correct ?

1 Yes

9 No

if we r using aggregator we enabled sorted input but the records r not sorted what happen?..

Answer / k gopi krishna

Session throws warning. can see it in log file
In case of Join , i guess session fails

Is This Answer Correct ?

0 Yes

8 No

Post New Answer