Interested to Buy Any Domain ? << Click Here >> for more details...
when i was running the seesion, after loading 100 records,
session suddenly fails.Next time i want to load the remaing
rows in target with out truncate target table.What should i
use?
- 7 Answers
- 17614 Views
- Cegedim, IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bsgsr
hi, suresh,
go for session recovery if you run in normal mode.
if it is a bulk mode session only option is to truncate the
table and run the session again.
| Is This Answer Correct ? | 23 Yes | 1 No |
Answer / raveendra g
By using Performance recovery option we can close this
issue.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rakhee
Try using mapplet variable
It helps to load data in the part.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / powerstar
session recovery works much better if it is run in normal mode.
If the load type is bulk mode, then session recovery is compromised.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishna
gayathri,
if you work in the same manner probably there is a chance
of record duplicates to be loaded if you restart the session
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / gayathri
Go to workflow manager. choose mapping. There u uncheck the
box truncate table. This shd. load ur remaining rows
without truncating the previously loaded records.
| Is This Answer Correct ? | 1 Yes | 11 No |
What is informatica?
What is the surrogate key?
How to delete duplicate record in Informatica?
What is the difference between Bulk Load and Normal Load
How can u stop a batch?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
What is the different lookup cache(s)?
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
What is mapping debugger?
What is source qualifier transformation?
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
Teradata 
