Answer Posted / dhirendra

Reads an input record from the in port.
Passes the input record to the get_filename transform
function.
If the get_filename function returns a string that does not
contain a valid filename, or if the file derived from the
string is empty or missing, Read Multiple Files proceeds
according to what is specified in the filename-error, file-
empty, and file-missing parameters.
If the get_filename function returns a string containing a
valid filename, Read Multiple Files retrieves the specified
file.
NOTE: The input file specified in the string must be local
to the machine where Read Multiple Files is running. Note
also that in multifile layouts, different instances of Read
Multiple Files can be running on different computers, so
input filenames referring to directories that exist only on
particular computers must be partitioned carefully. To use
relative paths, use the DML function this_partition_path.

Opens the specified file and reads records from it:
If an input_type data type is defined in the transform
package, Read Multiple Files uses this type to read records
from the file. If you omit input_type, Read Multiple Files
uses the record type defined on the out port.
If the filter parameter was set to Range, and the skip-
count parameter is non-0, Read Multiple Files skips the
specified number of records before reading subsequent
records from the file.
If the filter parameter was set to Range, and the read-
count parameter is non-0, Read Multiple Files reads up to
this maximum number of records from the file. If read_count
is less than or equal to zero, Read Multiple Files reads
the remainder of the file.
Read Multiple Files writes records to the out port.
If a reformat function is defined in the transform package,
the component passes each record read from the input file
to the reformat function, along with the filename. The
output of the reformat function is written to the out port.
If you omit a reformat function, but provide an input_type
data type in the package, the component behaves like a
Reformat component with no transform package, reading
records from the file using the input_type, and performing
any conversion necessary to match the record format on the
out port.
If the reject and error ports are connected to flows and
the reformat transform function returns NULL, Read Multiple
Files writes an error message to the error port and the
current record to the reject port.
Read Multiple Files stops execution of the graph when the
number of reject events exceeds the value given by the
following formula:

limit + (ramp * number_of_records_processed_so_far)

For details, see "Setting limit and ramp for reject events"

If you do not connect flows to either the reject or error
port, Read Multiple Files does not write an error message
and discards the rejected record.

Code check-in and check-out commands in AbInitio

4247

---

What the difference between “look-up” file and “look is up” in abinitio?

1304

---

How do you improve the performance of a graph?

1084

---

Explain how abinitio eme is segregated?

1433

---

How to compare two dmls in abinitio

1776

---

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

1029

---

what is the output when -1 is put in select_expr of FBE?

1374

---

Describe in detail about lookup?

1035

---

What is sort component in abinitio?

1173

---

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

3346

---

How would you find out whether a sql query is using the indices you expect?

1013

---

What information does a .dbc file extension provides to connect to the database?

1173

---

How co>operating system integrates with legacy codes?

1095

---

Define ramp limit in ab initio?

1202

---

What is the difference between look-up file and look-up, with a relevant example?

1146

---