We can achieve better perfomance using sorter before an
aggragator. Then what is the significance of 'Sorted Input'
check in aggregator ?? Please let me know the difference ??
Answers were Sorted based on User's Feedback
Answer / guest
Typo error in my previous post.
Integration service is not intelligent enough to know the
data is sorted. So If "Sorted Input" Option is checked,
then Integration service understands that the input data to
the Aggregation Transformation is sorted.
Regards,
Kumar
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / guest
Integration service is not intelligent enough to know the
data is sorted. So If "Sorted Input" Option is checked,
then Integration service understands that the input data to
the sorter Transformation is sorted.
Regards,
Kumar
| Is This Answer Correct ? | 3 Yes | 1 No |
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
What exactly mentioned in High level design document.can somebody explain me sequentialy.
what is the monster dimension plz give me one example
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
What are partitions in informatica and which one is used for better performance?
What are the types of maping wizards that r to be provided in Informatica?
can u any challenge your project?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
Two different admin users created for repository are ______ and_______
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...