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 |
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
What is informatica etl tool?
Explain what is informatica metadata and where is it stored?
What are the data movement modes in informatcia?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
Reusable transformation and shortcut differences
Explain why we use partitioning the session in informatica?
What is lookup change?
in static and dynamic which one is better
What are the issues you have faced in your project? How did you overcome those issues?
How to extract original records at one target & Duplicate records at one target?