Explain the ab initio etl tool in high level?
What parallelisms does Abinitio support?
What are the primary keys and foreign keys?
What are the different types of parallelism in ab initio?
What are the various types of layout supported by abinitio?
What are the differences between informatica and abinitio?
What is conduct>it?
How co>operating system integrates with legacy codes?
Explain what is sandbox?
Mention what the difference between “look-up” file and “look is up” in abinitio?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?
Runtime behavior of Normalize and Reformat
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)?
What do you mean by a transaction file and how it is different from that of a sort file?