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

What is olap (on-line analytical processing?

0 Answers  


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

0 Answers   SeeInfoBiz, TCS,


what is the look up transformation?

2 Answers   Informatica,


sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,


Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  


What is operational data source (ODS)?

7 Answers  


What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  


how to delete duplicate records by using filter transfermation?

3 Answers  


What is InformaticaPowerCenter?

0 Answers   Informatica,


performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,


Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,


How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,


Categories