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
How to start a workflow using pmcmd command?
How to update source definition?
What is the format of informatica objects in a repository?
What is the difference between a repository server and a powerhouse?
What is repository manager?
How can we use batches?
What is exclusive and normal mode for repository services?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are connected or unconnected transformations?
Explain the types of lookup transformation?
differences between service based and product based?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
In development project what is the process to follow for an etl developer from day1
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you