Ab Initio Interview Questions
Questions Answers Views Company eMail

What do you mean by the term data warehousing?

619

Do you think effective communication is necessary for data processing?

724

Is data warehousing different from data mining?

631

How data is processed and what are the fundamentals of this approach?

640

How scientific data processing is different from commercial data processing?

626

What would be the next step after collecting the data?

726

Give one reason when you need to consider multiple data processing?

627

We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?

786

Have you ever encountered an error called “depth not equal”?

649

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

559

What do you mean by a transaction file?

670

Difference between informatica vs ab initio?

705

How transaction file different from that of a sort file?

883

Mention what is abinitio?

594

Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump

1 2920


Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

How data is processed and what are the fundamentals of this approach?

640


Mention how can you connect eme to abinitio server?

859


Mention some file extensions which are used in abinitio?

616


Define ramp limit in ab initio?

765


What is a partition?

714






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?

3894


We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

883


To which project that prefix will set is to private project or public project or both?how and where to set?

1394


What is a rollup component? Explain about it.

677


Explain PDL with an example?

801


What is a local lookup?

692


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

641


What do you know about abinitio?

758


how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio

1288


What is conduct>it?

628