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
- 9617 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 |
generate date / time dimension in informatica
Can we insert and update a target table without using update strategy transformation?How?
What is the term PIPELINE in informatica ?
What is dimensional table?
what is scd?
How to improve the performance of Aggregate transformation?
Informatica settings are available in which file?
Explain sessions and how many types of sessions are there?
what is unique constraint error ?
What are the different threads in DTM process?
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
What are the differences between oltp and olap?
Teradata 
