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
- 9434 Views
- I also Faced
- E-Mail Answers
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 |
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
How to jion 2 tables, without using any condition?
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
How i can upload the MainFrame source For Informatica ?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
performance wise which one is better in joiner and lookup transformation
Separate from an archive server and a powerhouse?
what are the real time problems generally come up while doing or running mapping or any transformation?
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
what is left outer join?
What is deployment group?
Teradata 
