how will i can implemate Insert,Update,delete in abinitio?
how will u view MFS in unix?what is diff/btween conditional
dml& conditional component?

Answer Posted / r.sekhar

u can do using update table component.In this we can connect
the database using .dbc i.e. database configure file, and
then browse the table ten convert to output file component
using same dml. then that component to update table
component. then we can change the data in the input
component like update table using sql quarry panel ...
We can also do delete from the table using same sql quarry
in the dml...
using truncate component we can do truncate a table also..

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?

1029


How would you find out whether a sql query is using the indices you expect?

802


What do you understand by a cartesian join?

864


can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2002


What is MAX CORE of a component?

943


What is a look-up?

848


Do you know what a local lookup is?

867


I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?

1813


Why do you think data processing is important?

849


How to move or copy the project parameter or project object to my sandbox?

2038


What are the Types of parallelism in detail?

879


What are the components new in 2.14 compared to 1.8 and State the usage of the components?

1947


What do you mean by a transaction file and how it is different from that of a sort file?

811


How transaction file different from that of a sort file?

1130


What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?

775