In aggregator if u enable sorted input what will be the
output and disable sorted wt is output

Answers were Sorted based on User's Feedback



In aggregator if u enable sorted input what will be the output and disable sorted wt is output..

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

In aggregator if u enable sorted input what will be the output and disable sorted wt is output..

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

In aggregator if u enable sorted input what will be the output and disable sorted wt is output..

Answer / chandra babu naidu

hi try this senario session will fail

Is This Answer Correct ?    0 Yes 0 No

In aggregator if u enable sorted input what will be the output and disable sorted wt is output..

Answer / krish

if disable session wil fail

Is This Answer Correct ?    1 Yes 1 No

In aggregator if u enable sorted input what will be the output and disable sorted wt is output..

Answer / chandrababu naidu

session will failed because it accepts only sorted input

Is This Answer Correct ?    2 Yes 6 No

In aggregator if u enable sorted input what will be the output and disable sorted wt is output..

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

Post New Answer

More Informatica Interview Questions

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,


i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,


Explain what transformation and how many are there in informatica?

0 Answers  


without using rank transformation how can we rank items by using some other transformations

2 Answers  


How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,


Define Incremental Aggregation?

2 Answers  


there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  


Why the workflow is failed after running two hours in informatica?

1 Answers   GE,


What is the function of union transformation?

0 Answers  


Which will beter perform IIf or decode?

3 Answers   TCS,


I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  


Explain about Recovering sessions?

1 Answers  


Categories