Answer Posted / learner

use m_expand command, it will give list of partitioned file, than wc -l on specified file name give number of records

What do you understand by a cartesian join?

768

---

What do you mean by the term data warehousing? Is it different from data mining?

782

---

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

1895

---

Explain the difference between the truncate and delete commands?

713

---

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

756

---

---

What is the difference between partitioning with key / hash and round robin?

732

---

List out some of the air commands used in abintio?

885

---

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

1552

---

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

617

---

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

1922

---

Mention what is the syntax for m_dump in abinitio?

1057

---

Explain PDL with an example?

917

---

What is abinitio?

783

---

How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?

3996

---

What is data mapping and data modelling?

1080

---