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

How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

1024

---

Pdl with an example?

1048

---

What do you mean by data sorting?

1112

---

When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

1067

---

difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

2768

---

What are the fundamental blocks of co> operating system of ab initio?

1190

---

What are the components new in 2.14 compared to 1.8 and State the usage of the components?

2164

---

What exactly do you understand with the term data processing and businesses can trust this approach?

1043

---

What are the facts that can compromise data integrity?

1085

---

Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

1047

---

What is brodcasting and replicate?

1157

---

Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

995

---

Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?

1059

---

What is a cursor? Within a cursor, how would you update fields on the row just fetched?

1120

---

What do you understand by overflow errors?

1156

---