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 / 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 |
Post New Answer View All Answers
What is a partition?
Mention what dedup-component and replicate component does?
What is ab initio enterprise meta>environment (eme)?
How can we increase the loading performance of oracle table in AbInitio?
What dedup-component and replicate component does?
What are the fundamental blocks of co> operating system of ab initio?
What does edp stand for?
Explain what is sort component in abinitio?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
how to insert/update a csv file by comparing it with another csv file?
What metadata importer can do in ab initio?
What do you understand by local lookup?
Is data warehousing different from data mining?
Mention what is a partition and what are the different types of partition components in abinitio?