Interested to Buy Any Domain ? << Click Here >> for more details...
if we r using aggregator we enabled sorted input but the
records r not sorted what happen?
- 7 Answers
- 22185 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
Define enterprise data warehousing?
where to store informatica rejected data? How to extract the informatica rejected data?
How can you define user defied event?
What is Data Caches size?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is informatica metadata and where is it stored?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are roles and groups and benefits of using them?
What are the different components of powercenter?
What is dimensional table?
Implementation methodology
What do you mean by channel change?
Define joiner transformation?
Can we create two repositories on same database instance in oracle?
