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?
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 |
How can yoU improve session performance in aggregator transformation?
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
Roles and Responsibilties of Informatica Production Support Member?
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
What are the designer tools for creating tranformations?
How we can confirm all mappings in the repository simultaneously?
Can informatica load heterogeneous targets from heterogeneous sources?
can you please explain me pre session and post session options?
can we override a native sql query within informatica? How do we do it?
What if the source is a flat-file?
i have two source data there is no pk,fk how to join the two sources
What is flashback table ? Advance thanks