Interested to Buy Any Domain ? << Click Here >> for more details...
yesterday my session run ten min.today its run 30min, wt is
the reason? if any issues how to solve that?
- 2 Answers
- 6713 Views
- iGate, I also Faced
- E-Mail Answers
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 |
Is informatica power center designer has 64 bit support?
SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve
how did u understand business requirement?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
How can we delete duplicate rows from flat files?
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
What is staging area?
How to Join Tables my Source is having 15 table target is one?
What are the reusable transformations?
When you move from devel to prod how will you retain a variable
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
Teradata 
