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 |
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?
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.
Explain what transformation and how many are there in informatica?
without using rank transformation how can we rank items by using some other transformations
How to Join Tables my Source is having 15 table target is one?
Define Incremental Aggregation?
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
Why the workflow is failed after running two hours in informatica?
What is the function of union transformation?
Which will beter perform IIf or decode?
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?
Explain about Recovering sessions?