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?
Answers were Sorted based on User's Feedback
Answer / lyubov podolskaya
to find records which should be inserted , updated or
deleted one should use ab initio flow
a. unload master table
b. read delta file
c. use inner join to join a and b unused a will be your
delete records (if required) unused b will be your insert
record . joined a and b will be your update records
to view MFS in unix you should run m_expand command
conditional DML can be pass as program variable
conditional components will be used only when condition past
to the graph is true
Is This Answer Correct ? | 24 Yes | 3 No |
Answer / 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 |
Answer / veluruabinitio
it will solve lookup and replicate just write query yes/no
Is This Answer Correct ? | 3 Yes | 21 No |
Output for sort and dedupsort with NULL key?
What is the latest version that is available in Ab-initio?
What is data encoding?
How to run the graph without GDE?
I have a DML in my local system the location is E:/u/home/khaleel/dml how to convert this path to $DML?
What do you mean by a transaction file and how it is different from that of a sort file?
How co> operating system natively processes the data?
Explain what is de-partition in abinitio?
How data is processed and what are the fundamentals of this approach?
Explain batch processing in ab initio?
How to add default rules in transformer?
Can any body give me the clear explanation about how to separate header,trailer and body records in Ab Initio?