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 |
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How the informatica server increases the session performance through partitioning the source?
What is the difference between warehouse key and surrogate key?
How to convert multiple rows to single row (multiple columns) in informatica
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
explain different levels in pushdown optimization with example?
write a query for how to eliminate the duplicate rows without using distinct?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
What are the types of schemas we have in data warehouse and what are the difference between them?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
what is the complex transformation you used in informatica