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
- 1 Answers
- 2117 Views
- I also Faced
- E-Mail Answers
Answer / Mohd. Imran Ansari
When a mapping runs for an extended period of time, there are several potential issues that could cause this behavior:
1. Check the mapping logs: Review the log files generated by Informatica PowerCenter during the execution of the mapping. Look for error messages or warnings that indicate potential issues.
2. Monitor resource usage: Ensure that the system has sufficient resources (CPU, memory, disk space) to run the mapping efficiently. If resources are limited, consider allocating more resources or optimizing the mapping to reduce its resource requirements.
3. Check the data quality: Inspect the source and target data for any anomalies or inconsistencies that might be causing the mapping to take a long time to complete.
4. Optimize the mapping: Review the mapping logic for opportunities to improve performance, such as reducing the number of lookups, optimizing joins, or using more efficient functions.
5. Use scheduling options: If the mapping is running continuously, consider setting up job scheduling options that allow you to control when and how often the mapping runs.
6. Contact support: If none of these steps resolve the issue, consult with Informatica Support for assistance troubleshooting the problem.
| Is This Answer Correct ? | 0 Yes | 0 No |
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
what is session override?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
which one is better performance wise joiner or look up
How to update or delete the rows in a target, which do not have key fields?
What is the cumulative sum and moving sum?
Explain lookup transformation is active in informatica
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
where to select code page option?
can we see default group,when we use router?if yes how?
What are the uses of etl tools?
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
Teradata 
