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

What is common among data validity and data integrity?

600


List out the file extensions used in abinitio?

661


Explain what is de-partition in abinitio?

834


How abinitio eme is segregated?

805


How do you truncate a table?

688






Have you used rollup component? Describe how.

664


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

1716


Suppose you find the term validation mentioned with a set of data, what does that simply represent?

585


What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?

723


What is a rollup component? Explain about it.

680


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

670


What are the Graph parameter?

692


Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

862


What is publickey and private key?what is the use of this two keys?

2346


List out some of the air commands used in abintio?

721