1. What do you mean by AB-initio?
AB-initio is a tool used to extract, transform and load data.
2. What is the use of AB-initio tool?
We can use AB-Initio tool for data manipulation and analysis along with batch processing and GUI based Parallel processing methods.
3. What type of Architecture that AB-Initio Includes?
The Architecture of AB-Initio includes Enterprise Media Management, Graphical Development Environment, Cooperating System and Conduct-IT.
4. What are the features of AB-Initio?
The Features of AB-Initio Includes Managing and running of AB-Initio graph and ETL Process which provides AB-Initio extensions to the operating system. We can also monitor and debug ETL Operations along with Meta data Management and also interaction with Enterprise Media Management.
5. In to how many segments AB-Initio is segregated?
AB-Initio is segregated in to two different segments namely Data Integration and User Interface
6. What are the different file extensions used in AB-Initio?
The Different File extensions that are used in AB-Initio are .mp , .dat ,.xfr, .mpc, .mdc and .dml
7. Mention the different parallelisms used in AB-Initio?
Component Parallelism,Pipeline Parallelism and Data Parallelism are the three types of parallelisms that are used in AB-Initio.
8. Mention the different types of partition components used in AB-Initio?
The Different types of partition components that are used in AB-Initio are Round-Robin,Percentage,Expression,Range,Key,Load Balance .
9. Mention the different de-partition components in AB-Initio?
Merge,Gather,Interleave and Concatenation are different de-partition components that are available in AB-Initio.
10. What is the process of Truncating a table in AB-Initio?
In AB-Initio a table can be truncated in three different ways One way is to use Truncate table and other way is to Run program. We can also truncate a table by updating a table or Running an SQL Command.
11. What are the types of Joins in AB-Initio?
There are three different types of joins available in AB-Initio
They are Innerjoin, outerjoin and semi join.
12. What are the different parameters used in AB-initio?
Local and Formal are two different kinds of parameters used in AB-Initio.
13. In a graph ,how can you find the listed number of arguments defined?
$? –this symbol states the last executed command exit status and $# -this symbol states the total number of positional parameters available
0 comments:
Post a Comment