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
- 6721 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 is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the transformations that are not supported in mapplet?
without using rank transformation how can we rank items by using some other transformations
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
can u any challenge your project?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
Teradata 
