If m loading a file of 1 million records.and the graph fails
after loading 10,000 records.
In this case if we use rollback command then what will happen?

Answers were Sorted based on User's Feedback



If m loading a file of 1 million records.and the graph fails after loading 10,000 records. In this..

Answer / madhugreddy

If you rollback it starts loading from first record.

Is This Answer Correct ?    9 Yes 2 No

If m loading a file of 1 million records.and the graph fails after loading 10,000 records. In this..

Answer / kartheek

when used rollback, if graph have any checkpoints, it will asks u, again re-run that entire graph or continue from succeful checkpoint. every checkpoint contain that details.

Is This Answer Correct ?    5 Yes 2 No

If m loading a file of 1 million records.and the graph fails after loading 10,000 records. In this..

Answer / avijit

m_rollback will rollback all the records that has been loaded till the last successful check point of the graph.

Is This Answer Correct ?    5 Yes 2 No

If m loading a file of 1 million records.and the graph fails after loading 10,000 records. In this..

Answer / gautham kumar

It will undo the changes and it will undo the load as
well.Again the graph will start from the checkpoint

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Ab Initio Interview Questions

In Join component which record will go to unused port and which will go to reject port ?

3 Answers   JPMorgan Chase,


If you check in one file twice in EME, one with a tag and second without a tag - Will the version number change ? How to use in abinitio graph?

2 Answers   IBM, TCL,


What does it mean by the term 'sort component'?

0 Answers  


Why might the optimizer use a table scan when an index is available?

0 Answers  


Mention what is a partition and what are the different types of partition components in abinitio?

0 Answers  






How to calculate total memory used my a graph?

1 Answers   IBM,


What is is a data flow graph?

0 Answers  


11. What is the use of allocate()?

1 Answers   TCL,


What does dependency analysis mean in Ab Initio?

5 Answers   Syntel,


When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

0 Answers  


What is AB_LOCAL expression where do you use it in ab- initio?

5 Answers   Cognizant,


What is the difference between look-up file and look-up, with a relevant example?

0 Answers  


Categories