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 are “business rules” in ab initio business rules environment (bre)?

1419


What would be the next step after collecting the data?

726


Explain the ab initio etl tool in high level?

667


How does the bre work with the co>operating system?

601


To which project that prefix will set is to private project or public project or both?how and where to set?

1394






How to compare two dmls in abinitio

1184


What is the use of the co> operating system in ab initio?

613


How can we increase the loading performance of oracle table in AbInitio?

638


Explain data flow graph with an example?

630


What is a deadlock and how it occurs?

667


What are the various types of layout supported by abinitio?

579


What is data mapping and data modelling?

963


difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

2302


What are differences between different versions of co-op?

631


When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

654