I have 1200 records how can u send it in aggregator with
good performance issues?
Answers were Sorted based on User's Feedback
Answer / kishore
Before aggrgator transformation it's better to use Sorter
transformation, which will make them as sort, which will
increse the performance.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / drk
By using sorted input and group by function ,we can overcome
the performance issues
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What are the databases that informatica can connect to windows?
what is lookup chache?
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
What is DR strategy for Informatica project?
what are the difference between Informatica 7.1 and 8.1?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
how to run the batch using pmcmd command
How many types of sessions are there in informatica.please explain them?
How i can upload the MainFrame source For Informatica ?
What is main use of mapplet?
Define joiner transformation?