I have 1200 records how can u send it in aggregator with
good performance issues?
Answer Posted / drk
By using sorted input and group by function ,we can overcome
the performance issues
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is rank transformation?
What are mapplets?
What is the fact table?
Plz can any one say me how to get the informatica certification materials and dumps
How big was your fact table
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How does the aggregator transformation handle null values?
What is depict expression change?
What is aggregate cache in aggregator transformation?
what is the hint? how to use it to reduce the query processing in program?
What does “tail –f” command do and what is its use as an Informatica admin.
where to store informatica rejected data? How to extract the informatica rejected data?
How to generate or load values in to the target table based on a column value using informatica etl tool.