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
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 |
How to generate sequence numbers?
Which will beter perform IIf or decode?
Under which circumstances, informatica server creates reject files?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is the difference between lookup override and souce qualifier override ?
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
what is mean by grouping of condition column in lookup transformation?
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...
Whatis the difference between View and Materialized View ?