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 |
Where is the cache stored in informatica?
What are the types of data warehouses?
How can we use mapping variables in informatica?
While importing the relational source defintion from database,what are the meta data of source U import?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
What are the restrictions of union transformation?
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
How to delete first 3 rows & last 3 rows in target table in informatica
explain different types of modeling.
how can one eliminate dupliacte data with out using distinct option?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?