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
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 |
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 |
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
can we see default group,when we use router?if yes how?
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
Performance tuning( what you did in performance tuning)
How to load duplicate records in to a target table which has a primary key?
What is tracing level and what are the types of tracing level?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
Is there any way to read the ms excel datas directly into informatica?