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
- 9324 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 |
How do you load only null records into target? Explain through mapping flow.
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
Explain the tuning lookup transformation - informatica
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
what is the command to get the list of files in a directory in unix?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are the diffrences between joiner transformation and source qualifier transformation?
Is it possible to have "5 source & 5 Target" in single mapping?
Do you find any difficulty while working with flat files as source and target?
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
Teradata 
