Interested to Buy Any Domain ? << Click Here >> for more details...
How to recover sessions in concurrent batches?
- 3 Answers
- 15903 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 |
What are the session parameters?
How to extract sap data using informatica? What is abap? What are idocs?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
What does “tail –f” command do and what is its use as an Informatica admin.
what is the difference between static and dynamic
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.
How can you display only hidden files in UNIX
what is fact table?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How many ways you create ports?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Teradata 
