What is the difference between a utility and api in a RUN SQL component

Answer Posted / dinesh

api mode is put a lock on the table whereas Utility doesn't. is it ?

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a data processing cycle and what is its significance?

859


What is the ab initio business rules environment (bre)?

906


Explain what is sort component in abinitio?

862


Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

845


Tell us about the architecture of abinitio.

857


What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.

1092


How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

1744


How to add default rules in transformer?

903


What is the function you would use to transfer a string into a decimal?

922


What are the different types of partition components in abinitio?

1045


What exactly do you know about the typical data analysis?

791


What is the difference between rollup and scan?

1507


What is rollup component?

897


Is data warehousing different from data mining?

834


How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on

691