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
Mention what is a partition and what are the different types of partition components in abinitio?
How you can run a graph infinitely in ab initio?
How to move or copy the project parameter or project object to my sandbox?
Do you think effective communication is necessary for data processing? What is your strength in terms of same?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
When we should use 'jobid' for commit table (Output table component??
what is the project environment(for each project the environment is same or different to different project)?
How co>operating system integrates with legacy codes?
What dedup-component and replicate component does?
Explain what does dependency analysis mean in abinitio?
What kind of layouts does abinitio support?
What do you know about partition and also tell us about partition components in abinitio?
What are the six data process products of ab initio (architecture of ab initio)?
how to insert/update a csv file by comparing it with another csv file?
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.