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



yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve..

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

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve..

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

Post New Answer

More Informatica Interview Questions

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,


What are the types of data warehouses?

0 Answers   Informatica,


How can we use mapping variables in informatica?

0 Answers  


While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  


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..?

6 Answers  






What are the restrictions of union transformation?

0 Answers  


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

2 Answers   Wipro,


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!!

2 Answers  


How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,


explain different types of modeling.

2 Answers  


how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,


If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  


Categories