Ab Initio Data Interview Questions and Answers.
Explain how do you find whether a SQL query is using the indices you applied?Answer : We can extract the Explain plan which can be reviewed to check the execution plan of the query. This would tell us if the expected indexes are used or not.
How does MAXCORE works in Ab Initio?
Answer : Maxcore is a value (it will be in Kb).Whenever a component is executed in Ab Initio, it will take that much memory that we have specified for execution in MAXCORE.
Explain how do you create repository in Ab Initio for a stand alone system?
Answer : When you are trying to install the Ab -Initio on stand alone machine (LOCAL NT) , it is not necessary to create the repository , While installing the software, it automatically creates for the user which can be found under AbInitio directory
Explain how can you convert 4-way MFS to 8-way MFS in Ab Initio?
Answer : In oredr to convert 4-way MFS to 8-way MFS partition, we need to change the layout in the partitioning component. For this, there will be separate parameters for each and every type of partitioning
For instance. AI_MFS_HOME, AI_MFS_MEDIUM_HOME, AI_MFS_WIDE_HOME etc.
The most appropriate parameter is need to be selected in the component layout to be used for this type of partitioning.
Explain what is the difference between a clustered and non-clustered index and why do you use a clustered index? What do you mean by an outer join?
Answer : A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore a table can have only one clustered index. It is generally faster to read from a clustered index if you want to get back all the columns.
A non-clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. With a non clustered index there is a second list that has pointers to the physical rows.
Answer : A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore a table can have only one clustered index. It is generally faster to read from a clustered index if you want to get back all the columns.
A non-clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. With a non clustered index there is a second list that has pointers to the physical rows.
An outer join is used when one wants to select all the records from a port - whether it has satisfied the join criteria or not.
Explain about Partition by load balance in Ab initio
It reads records in arbitrary order from the flows connected to its in port and distributes those records among the flows connected to its out port by sending more records to the flows that consume records faster
Partition with Load Balance writes data records until each flow's output buffer fills up.
- Check all Ab Initio Interview Question and Answers Here
Related Posts
really its useful site above given information very helpful to me for prepare ab initio data warehousting interview thanks for given question and answers
ReplyDeleteAB INITIO Online Training