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
- 17450 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 |
When do you use mapping parameters? (In which transformations)
write a query for how to eliminate the duplicate rows without using distinct?
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
How can you join two tables without any common column present in them?
Explain the different kinds of facts.
Suppose we do not group by on any ports of the aggregator what will be the output?
Differentiate between a repository server and a powerhouse?
Is it possible to revert a global repository to local one and why?
How do you remove duplicate records in informatica?
How can we use mapping variables in informatica? Where do we use them?
Is it possible to create multiple domains on a single Informatica server?
What are the tasks that can be performed using sq?
Teradata 
