if we r using aggregator we enabled sorted input but the
records r not sorted what happen?
- 7 Answers
- 21332 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / krishnakanth.ch
When the 'Sorted Input' is enabled and if the data is not
sorted, then unexpected results will occur. It means the
session will succeed but the end result may not be the way
as per the business requirement.
Another point to be remembered is:
Group by columns in the Aggregator transformation must be
in the same order as they appear in the Sorter
transformation
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Why update strategy and union transformations are active?
Explain the features of connected and unconnected lookup.
Differentiate between joiner and lookup transformation?
Enlist the advantages of informatica.
update strategy transformation in informatica
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the main features of Oracle 8i with context to datawarehouse?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Can we change Dynamic to Static or Persistent cache? If so what happens?
How to Create a folder using pmrep command?
Repository user profiles
Do you find any difficulty while working with flat files as source and target?
draw informatica architecture 8.6 ?
What is data movement mode in Informatica and difference between them?
What is standalone command task?
