Answer Posted / ranga .

Find all the Ans as below...

How to read a feed file from UNIX prompt without opening Ab-
initio GDE?

Follow the below steps:
Create the DML for reading the feed file and save it
with .dml extension.
Place the DML file in the .dml folder of the respective
sandbox being used (can even be ignored).
Execute the following command at unix prompt:
m_dump <.dml file(absolute path)> <feed file name(absolute
path)>
Ex:
m_dump /export/home/read_feed.dml /export/home/feedfile.dat

For more options on m_dump, type m_dump help on unix prompt.

What is the difference between sandbox and EME?

1215

---

What is the difference between dml expression and xfr expression?

1044

---

What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?

3355

---

List out the file extensions used in abinitio?

1055

---

How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

1952

---

Why might the optimizer use a table scan when an index is available?

2259

---

What is the use of the co> operating system in ab initio?

1032

---

What is the purpose of having stored procedures in a data-based?

1020

---

What is a rollup component?

1088

---

Mention what is rollup component?

1074

---

Do you think effective communication is necessary for data processing? What is your strength in terms of same?

1097

---

What is a look-up?

1140

---

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

1055

---

What is a local lookup?

1186

---

What is a data processing cycle and what is its significance?

1163

---