how to improve performence by using sorted input in aggrigator
t/r.
Answer Posted / ramana
sorted input receives the sorted data as input to, improve
the performance of summary calculations
perform sort on group by ports using sorter t/r.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If informatica has its scheduler why using third party scheduler?
where to store informatica rejected data? How to extract the informatica rejected data?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What's the layout of parameter file (what does a parameter file contain?)?
What is the Rank index port in Rank transformation?
What is a filter transformation?
How can one identify whether mapping is correct or not without connecting session?
Clarify the utilization of aggregator cache record?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Explain informatica architecture - version 8 / 9
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Informatica settings are available in which file?