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

How can repository reports be accessed without sql or other transformations?

0 Answers  


Separate from an archive server and a powerhouse?

0 Answers  


What is workflow manager?

0 Answers  


What is a poling?

2 Answers  


I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers   ITC Infotech, TCS,






h0w many versions have been developed of onformatica so far?

1 Answers   TCS, TetraSoft,


What is the maplet?

0 Answers   Informatica,


How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  


what are the types of facts with Examples?

3 Answers  


What is the use of source qualifier?

0 Answers  


Do you find any difficulty while working with flat files as source and target?

0 Answers  


How can you increase the performance in joiner transformation?

0 Answers  


Categories