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 is fact table?
Which transformation should we use to normalise the COBOL and relational sources?
can u give example for factless fact table
What is target update override
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
what is the difference between static and dynamic
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
how to join the 2 different table with different columns in informatica?
Mention few power centre client applications with their basic purpose?
What is router transformation
what is Active lock explain
can every transfomation reusable?how?