Interested to Buy Any Domain ? << Click Here >> for more details...
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 ??
- 2 Answers
- 6294 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Define filter transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How we can use union transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the differences between oltp and olap?
What is an active transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is the procedure for creating independent data marts from informatica 7.1?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
write a query to retrieve the latest records from the table sorted by version(scd)
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain the types of lookup transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
what is the hint? how to use it to reduce the query processing in program?
