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

Explain the pipeline partition with real time example?

0 Answers   Informatica,


Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,


Can u generate reports in Informatica?

0 Answers   Informatica,


scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,


My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,






What are connected or unconnected transformations?

0 Answers   Informatica,


what are the types of facts with Examples?

3 Answers  


generate date / time dimension in informatica

0 Answers   Informatica,


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?

2 Answers   Emphasis,


I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,


when we dont use aggregator in mapping ?

2 Answers   CSC,


How many transformations can be used in mapplets.

0 Answers  


Categories