Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / gangadhar.goli

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

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,

Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 Answers  

if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,

What is degenerated dimention table?

7 Answers   Patni,

What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

what is distinct

4 Answers  

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,

Which transformation is needed while using the Cobol sources as source definitions?

0 Answers   Informatica,

Which development components of informatica have the highest usage?

0 Answers  

What are the differences between a connected lookup and unconnected lookup?

0 Answers  

For more Informatica Interview Questions Click Here
Categories