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 |
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
What is the difference between warehouse key and surrogate key?
How can we integrate different flat file data in a single mapping and with in a single execution
what r the values tht r passed between informatics server and stored procedure?
how may sources can be used in a mapping at a time?(limit)
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
Differentiate between source qualifier and filter transformation?
how can i invoke pmcmd in command line prompt
Why we use ENABLE HIGH PRECISION in session properties?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain about the concept of mapping parameters and variables ?
What is meta data and system catalog?