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
can we perform checkin and checkout through sandbox?
explain the environment varaibles with example?
Explain what is the architecture of abinitio?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
What are the types of data processing you are familiar with?
Explain the ab initio etl tool in high level?
What are “business rules” in ab initio business rules environment (bre)?
Do you think effective communication is necessary for data processing? What is your strength in terms of same?
To which project that prefix will set is to private project or public project or both?how and where to set?
How does the bre work with the co>operating system?
What does de-partition mean in abinitio?
What would be the next step after collecting the data?
The methods to improve performance of a graph?
Can you explain data flow graph with an example?