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

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..

Answer / veluruabinitio

it will solve lookup and replicate just write query yes/no

name the air commands in ab initio?

2 Answers   IBM, Syntel,

---

What is the difference between a DB config and a CFG file?

9 Answers   Wipro,

---

How do we handle if DML changing dynamicaly?

5 Answers   GE, HP, IBM, Mannar Company,

---

What is regex (lookup)? When you should use it?

3 Answers   HCL,

---

What does edp stand for?

0 Answers  

---

Mention what is the role of co-operating system in abinitio?

1 Answers  

---

How to calculate total memory used my a graph?

1 Answers   IBM,

---

What is the difference between rollup and scan?

0 Answers  

---

Describe the grant/revoke ddl facility and how it is implemented?

0 Answers  

---

What are the six data process products of ab initio (architecture of ab initio)?

0 Answers  

---

how can you convert 3 way to 7way partitioning in abinitio?

4 Answers  

---

Explain how abinitio eme is segregated?

0 Answers  

---