Interested to Buy Any Domain ? << Click Here >> for more details...
I have 1200 records how can u send it in aggregator with
good performance issues?
- 3 Answers
- 9610 Views
- I also Faced
- E-Mail Answers
Answer Posted / venkat
Provide sorted input before aggregation.
->Override default Sql from source Qualifier if the source
is relational-Use order by clause
(OR)
->Use Sorter transfermation to do the same
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Informatica settings are available in which file?
Name the different lookup cache(s)?
How to improve the performance of a session using sorter transformation?
Difference between Target-based loading and constraint-based loading?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Partition, what happens if the specified key range is shorter and longer
Why is sorter an active transformation?
How do you set a varible in incremental aggregation
What are the tasks that can be performed using sq?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What are pre and post-session shell commands?
what is the size of your data warehousing?
What is event and what are the tasks related to it?
How to do the error handling of if ur source is flatfiles?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
