Ab Initio Interview Questions
Questions Answers Views Company eMail

What do you mean by the term data warehousing?

613

Do you think effective communication is necessary for data processing?

720

Is data warehousing different from data mining?

624

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

634

How scientific data processing is different from commercial data processing?

622

What would be the next step after collecting the data?

721

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

623

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

782

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

641

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

552

What do you mean by a transaction file?

667

Difference between informatica vs ab initio?

696

How transaction file different from that of a sort file?

880

Mention what is abinitio?

589

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 2904


Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

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

694


How to create a repository in abinitio for stand-alone system(local nt)?

615


What is the purpose of having stored procedures in a data-based?

561


what is the use of catlog or catlogfile?

1913


What are the benefits of data processing according to you?

695






What are the reasons for which business can trust the approach of data processing?

613


What do you mean by the overflow errors?

738


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

1388


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

1410


Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

619


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

1281


Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

648


Why might the optimizer use a table scan when an index is available?

1803


Why is data processing considered beneficial?

607


What is the difference between check point and phase?

676