How to recover sessions in concurrent batches?
- 3 Answers
- 14704 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 |
4 yrs etl devloper roles and responsibilities?any body give solutions
What are the diffrences between joiner transformation and source qualifier transformation?
what is session parameters?
What are the types of schemas we have in data warehouse.
What are partitions in informatica and which one is used for better performance?
What are the main features of Oracle 8i with context to datawarehouse?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How do you handle decimal places while importing a flatfile into informatica?
How can we remove the duplicates from flat file source?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
What is the maplet?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
Teradata 
