Answer Posted / 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 |
Post New Answer View All Answers
How to partition the Session?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is the fact table?
What is meant by lookup transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is event and what are the tasks related to it?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is the Rank index port in Rank transformation?
How to use pmcmd utility command?
What is intricate mapping?
What is different between the data warehouse and data mart?
While migrating the data from one environment to another environment how would you manage the connections?
Mention few advantages of router transformation over filter transformation.
Enlist the various types of transformations.
How to join three sources using joiner? Explain though mapping flow.