Ab Initio Interview Questions
Questions Answers Views Company eMail

How do you add default rules in the transformer?

937

Within a cursor, how would you update fields on the row just fetched?

851

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

874

What are the key elements of a data processing system?

934

What are the kinds of layouts does ab initio supports?

772

What are the primary keys and foreign keys?

785

What exactly do you understand with the term data processing and businesses can trust this approach?

870

Have you used the rollup component? Describe how?

897

What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?

963

Explain about ab initio’s dependency analysis?

869

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

786

Describe in detail about lookup?

846

Why do you think data processing is important?

885

What are the steps to create a repository in ab initio?

981

What are the facts that can compromise data integrity?

899


Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

What is de-partition in abinitio?

1135


When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

879


How do you improve the performance of a graph?

873


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

1760


What is is a data flow graph?

876


What is common among data validity and data integrity?

801


Mention some ways for improving performance of a graph?

828


How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

1773


i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?

1848


What happens when we provide null key to sort, merge and pbks in Abinitio ?

1315


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

874


What are the features of ab initio?

861


Why is data processing considered beneficial?

803


Pdl with an example?

880


Explain what is de-partition in abinitio?

1070