yesterday my session run ten min.today its run 30min, wt is
the reason? if any issues how to solve that?
- 2 Answers
- 6168 Views
- iGate, I also Faced
- E-Mail Answers
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 are mapplets?
Why filter transformation is an active one?
What is depict expression change?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the various types of transformation?
How many input parameters can exist in an unconnected lookup?
How to start a workflow using pmcmd command?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
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
What are the types of schemas we have in data warehouse.
What are the static cache and dynamic cache in informatica?
wat are deployement groups in informatica, how it will be used for developers
How to load a Dimension ? and how to load a fact table?
What is option by which we can run all the sessions in a batch simultaneously?
