yesterday my session run ten min.today its run 30min, wt is
the reason? if any issues how to solve that?
Answers were Sorted based on User's Feedback
Answer / babu
Hi,
As per my knowledge only the reson is the amount of the
source data is too high compare to previous data.
| Is This Answer Correct ? | 14 Yes | 5 No |
Answer / gyana
delay of session
-----------------------
(1) amount of source data may huge
(2) database connection may slow down,thats y data transfer is slow
(3) if ur using cache based t/r,dn there must be performance issue in cache part
SOLUTIONS
-----------
(1) CHECK THE \DATABASE CONNECTIONS AND NETWORK SPEED
(2) CHECK CACHE SIZE
(3) MINIMISE THE USE OF CACHE BASED T/R USE
IF I AM WRONG DN LET ME NOW..MY MAIL ID IS(gyana.informatica@gmail.com)
| Is This Answer Correct ? | 8 Yes | 0 No |
What are mapplets? How is it different from a Reusable Transformation?
can we use cartesian join in informatica
What is InformaticaPowerCenter?
What are the types of maping in Getting Started Wizard?
how to get the first row without using rank t/r?
How to load duplicate records in to a target table which has a primary key?
Is it possible to define a single node as a Gateway node as well as worker node?
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
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
What are mapplets?
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?