yesterday my session run ten min.today its run 30min, wt is
the reason? if any issues how to solve that?
Answer Posted / 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 |
Post New Answer View All Answers
What is informatica?
Explain sql transformation in script mode examples in informatica
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is meant by LDAP users?
Explain lookup transformation source types in informatica
Explain what transformation and how many are there in informatica?
What are the different types of olap? Give an example?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is rank index in rank transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to create Target definition for flat files?
What is intricate mapping?
What are data-driven sessions?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Define joiner transformation?