Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 31328 Views
- IBM, Syntel, I also Faced
- E-Mail Answers
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
Explain batch processing in ab initio?
Define ramp limit in ab initio?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
What are the reasons for which business can trust the approach of data processing?
What is MAX CORE of a component?
What is the core of co> operating system?
How data is processed and what are the fundamentals of this approach?
What do you understand by overflow errors?
Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
Have you worked with packages?
Explain what is the architecture of abinitio?
How to compare two dmls in abinitio
Where $mpjret is used in ab-initio?
How many components in your most complicated graph?
Have you used the rollup component? Describe how?
