Ab Initio Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Ab Initio Interview Questions

Questions Answers Views Company eMail

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

1095

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

1100

What are differences between different versions of co-op?

1208

What does it mean by the term 'sort component'?

1097

What do you understand by a cartesian join?

1117

Why is data processing considered beneficial?

1062

What do you understand by overflow errors?

1243

What are the various types of layout supported by abinitio?

1030

How is the partitioning with key different from round robin partition?

1218

What do you know about partition and also tell us about partition components in abinitio?

1058

What are the functions of the replicate and dedup component?

1092

Tell us about the architecture of abinitio.

1099

In abinitio, what types of parallelism are used?

1091

How can a graph be run infinitely?

1126

Mention some file extensions which are used in abinitio?

1120

Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

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

1129

Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

1344

List out the file extensions used in abinitio?

1094

what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?

4001

What is local and formal parameter?

1402

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

1163

Mention what is abinitio?

995

What information does a .dbc file extension provides to connect to the database?

1233

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?

4400

When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?

1151

Is data warehousing different from data mining?

1091

How can I run the 2 gui merge files?

1179

How co>operating system integrates with legacy codes?

1175

What is the purpose of having stored procedures in a database?

1152

What is sort component in abinitio?

1225

For More Un-Answered { Ab Initio } Questions Click Here