Answer Posted / dhirendra

There can be many ways to remove header & trailer record
depending on the data you are receiving. If you have a
particular signature for header & Trailer record you can
use Filter by Expression or Partition By Expression
Component to remove the header & Trailer record. If you
don't have signature for your header & Trailer record then
you have to use reformat component to select only the data
record.

What is the function you would use to transfer a string into a decimal?

1230

---

What are the kinds of layouts does ab initio supports?

1003

---

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

1057

---

Explain what is sandbox?

1097

---

What is a deadlock and how it occurs?

1172

---

What are the facts that can compromise data integrity?

1154

---

In abinitio, what types of parallelism are used?

1096

---

When we should use 'jobid' for commit table (Output table component??

9113

---

How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?

2117

---

What are the types of data processing you are familiar with?

1219

---

Why might you create a stored procedure with the with recompile option?

1135

---

How do you add default rules in transformer?

1234

---

What are the differences between informatica and abinitio?

1225

---

What do you know about partition and also tell us about partition components in abinitio?

1058

---

You can ask about different vector functions. How to use in abinitio graph?

5549

---