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

can we perform checkin and checkout through sandbox?

1182

---

What is publickey and private key?what is the use of this two keys?

2905

---

What do you understand by local lookup?

1163

---

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

2837

---

What are “business rules” in ab initio business rules environment (bre)?

2023

---

Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

1154

---

Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

1128

---

What are the different types of parallelism in ab initio?

1222

---

What is the difference between formal and export parameter? Export at what secenario we are going to use?

2643

---

What are the steps to create a repository in ab initio?

1258

---

How co> operating system natively processes the data?

1104

---

What is brodcasting and replicate?

1213

---

We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?

1367

---

What is a partition and what are the different types of partition components in abinitio?

1275

---

How transaction file different from that of a sort file?

1418

---