In aggregator if u enable sorted input what will be the
output and disable sorted wt is output
- 6 Answers
- 11525 Views
- I also Faced
- E-Mail Answers
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 |
what is persistant cache in which situation we will use persistantcache
disable caching in a lookup transformation?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
How to load last n records of file into target table - informatica
How to load the data from a flat file into the target where the source flat file name changes daily?
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
what is session parameters?
What is the status code in stored procedure transformation?
How do you handle decimal places while importing a flatfile into informatica?
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
Teradata 
