How can you recover the session in sequential batches?
Answer / swetha
If you configure a session in a sequential batch to stop on
failure, you can run recovery starting with the failed
session. The Informatica Server completes the session and
then runs the rest of the batch. Use the Perform Recovery
session property
To recover sessions in sequential batches configured to stop
on failure:
1.In the Server Manager, open the session property sheet.
2.On the Log Files tab, select Perform Recovery, and click OK.
3.Run the session.
4.After the batch completes, open the session property sheet.
5.Clear Perform Recovery, and click OK.
If you do not clear Perform Recovery, the next time you run
the session, the Informatica Server attempts to recover the
previous session.
If you do not configure a session in a sequential batch to
stop on failure, and the remaining sessions in the batch
complete, recover the failed session as a standalone session.
Is This Answer Correct ? | 3 Yes | 0 No |
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
Explain in detail scd type 2 through mapping.
What is target update override
How to load a Dimension ? and how to load a fact table?
What is log file,and where is it located,why u r using the log file
what is data modelling? what are types of modelling?In which suituation will use each one?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
SO many times i saw "$PM parser error " .what is meant by PM?
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
What are 2 modes of data movement in Informatica Server?
what is the difference between stop and abort