yesterday my session run ten min.today its run 30min, wt is
the reason? if any issues how to solve that?
- 2 Answers
- 6148 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 |
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
What is data caches/ index caches?
What is an active transformation?
what are the challenge face in u r project?explain me
Performance wise which is better joiner or look up ? Give me with example?
Why we need XMLs?
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
What is confirmed fact in dataware housing?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are the types of data that passes between informatica server and stored procedure?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you
Teradata 
