how do u handle performance issues in Informatica . where
can u monitor the performance ?
- 1 Answers
- 4816 Views
- I also Faced
- E-Mail Answers
Answer / Dheeraj Kumar
To handle performance issues in Informatica, you can follow these practices:
1. Optimize data loading by sorting and aggregating data before transformation.
2. Use efficient data types and avoid using large data types unnecessarily.
3. Optimize database connections and minimize the number of round trips to the database.
4. Use caching, buffering, and parallel processing where applicable.
5. Monitor sessions and check for long-running processes or stuck sessions.
Performance can be monitored using the Informatica Monitor tool, which provides a comprehensive view of session status, performance metrics, and resource usage.
| Is This Answer Correct ? | 0 Yes | 0 No |
When do we go for the tools in the market?
what is session partitioning?
Do we need an etl tool?
What is tracing level? How many types of transformations supported by sorted input?
how would u estimate the size of Lookup transform data and index cache?
Identifying the bottlenecks in various components of Informatica and resolving them.
How many types of transformations supported by sorted input?
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way
what is the advantage of persistent cache? when it should be used?
What is lookup table in etl testing?
if i have a query as flat file how can we load data to target table
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
Teradata 
