What is difference between API

Question Posted / archana reddy

2 Answers
11748 Views
CitiGroup, IBM, TCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is difference between API..

Answer / sreedevi

In API mode, the insertion of data into database follows all the constraints of database. The API mode will interact with the database on a per-record basis. This means that every record is handled by the database But in Utility mode, that disables the constraints & inserts the data into database.

Is This Answer Correct ?

3 Yes

0 No

What is difference between API..

Answer / rose24

It is possible to use sql statements in API mode but it is not available in Utility Mode

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Ab Initio Interview Questions

How to load the data from an excel sheet to input file in a graph?

2 Answers IBM,

What metadata importer can do in ab initio?

0 Answers

Can you use scan to generate sequence number ? How to use in abinitio graph?

2 Answers IBM, TCL,

Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump

1 Answers

After completion of graph what is the next process to perform? who will perform the later process?

1 Answers

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

0 Answers

What is standard environment ? How to use in abinitio graph?

1 Answers IBM, TCL,

) How can you count the total no .of records in the specified partition in the Multifile?

5 Answers

What are the six data process products of ab initio (architecture of ab initio)?

0 Answers

Describe the effect of the "checkpoint" t-sql statement?

1 Answers

Why do you think data processing is important?

0 Answers

What is a local lookup?

0 Answers

For more Ab Initio Interview Questions Click Here