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.

How to add default rules in the transformer?

1174

---

How to replace last 4 digits of an input column with XXXX given input column has 12 digits?

1040

---

What are the facts that can compromise data integrity?

1101

---

What are the differences between informatica and abinitio?

1177

---

Is data warehousing different from data mining?

1055

---

Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com

2281

---

What is the difference between check point and phase?

1240

---

What is a rollup component? Explain about it.

1136

---

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

1011

---

What do you mean by data sorting?

1141

---

What does edp stand for?

1118

---

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

1169

---

Can you explain the co>operating system’s processing model?

1058

---

what is the project environment(for each project the environment is same or different to different project)?

2177

---

What exactly do you know about the typical data analysis?

1061

---