How can yoU improve session performance in aggregator
transformation?
Answer Posted / srikanth
hi haritha
u r correct
For using sorted input option, the order of group by ports
in the agg and sorter transfomratoins should be same as
well as the number of ports also same.
we can filter out data early in the morning by using sq
trans rather than using filter before agg hence reducing
unwanted data in teh mapping.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
write a query to retrieve the latest records from the table sorted by version(scd)
Explain lookup transformation source types in informatica
How can you differentiate between powercenter and power map?
What is the benefit of partitioning a session?
What is persistent lookup cache?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is a sorter transformation?
What is data transformation manager process?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are roles and groups and benefits of using them?
can u any challenge your project?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is the need of an ETL tool?
What is fact table? Explain the different kinds of facts.
What are junk dimensions?