Interested to Buy Any Domain ? << Click Here >> for more details...
How to recover sessions in concurrent batches?
- 3 Answers
- 15769 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krishna
when we use concurrent process to load when session
fails ...all other session will run normally and load the
data..the failed session will considered as a standalone
sesion ...and we have perform recovery for the failed
session.
there three type where we can recover a failed session
1.start the session again if the Informatica server doesnt
perform the commit
2.else perform recovery on the session
3. if we can recover the session truncacte the data from
target table and run the session.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / aswin
Its purely depending on the way the design involved..Recovery strategy is not possible with flatfile targets..If commit happens inbetween, there is no point in running session from beginning
so manual intervention is required to restat the flatfile target load fails
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / seshagiri k
by removing the target table and run the session again
if it is wrong pls send the answer to my mail
| Is This Answer Correct ? | 0 Yes | 0 No |
how can one come to know wether the records loak into the target if we use update strategy
How to recover the standalone session?
which one is better either active or passive transformation in informatica
why we use stored procedure transformation?
What is the query to find nth highest salary? What is the use of cursors?
What is a pre-defined event and user-defined event?
how to identify new and old values in source qualifier or any other transformations using informatica
What is incremental aggregation?
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
What is the different lookup cache(s)?
What is data movement mode in Informatica and difference between them?
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
Teradata 
