Describe the effect of the "checkpoint" t-sql statement?
Answer / anonymous
checkpoints are normally used for the graph recovery.
if we are loading a large volume of data and the graph gets failed, so instead of rerunning the whole graph we can execute the graph from the last executed checkpoint.
it saves time and loads the data from the point where it failed.
checkpoints saves the intermediate files during the graph execution.
Is This Answer Correct ? | 1 Yes | 0 No |
what is decoding & what is NVL?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
Explain what is de-partition in abinitio?
What is .abinitiorc and What it contain?
Mention what information does a .dbc file extension provides to connect to the database?
what is meant by fancing in abinitio ?
What are the components new in 2.14 compared to 1.8 and State the usage of the components?
List out some of the air commands used in abintio?
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?
Mention what are the different types of parallelism used in abinitio?
Describe the effect of the "checkpoint" t-sql statement?
Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?