In aggregator if u enable sorted input what will be the
output and disable sorted wt is output
- 6 Answers
- 10933 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 the need of building a data warehouse?
What are the different lookup cache(s)?
What is the target load order?
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
How do you remove duplicate records in informatica? And how many ways are there to do it?
what is difference between COM & DCOM?
where to store informatica rejected data?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
How do you handle two sessions in Informatica
difference between informatica 8.1.1 and 8.6
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
What are the different components of powercenter?
Teradata 
