Ab Initio Job Interview Questions

And Answers

Interview Questions Answers

https://interviewquestionsanswers.org/
 About Interview Questions Answers

Interview Questions Answers . ORG is an interview preparation guide of thousands of Job

Interview Questions And Answers, Job Interviews are always stressful even for job seekers who have
gone on countless interviews. The best way to reduce the stress is to be prepared for your job
interview. Take the time to review the standard interview questions you will most likely be asked.
These interview questions and answers on Ab Initio will help you strengthen your technical skills,
prepare for the interviews and quickly revise the concepts.

If you find any question or answer is incorrect or incomplete then you can submit your question or
answer directly with out any registration or login at our website. You just need to visit Ab Initio
Interview Questions And Answers to add your answer click on the Submit Your Answer links on the
website; with each question to post your answer, if you want to ask any question then you will have a
link Submit Your Question; that's will add your question in Ab Initio category. To ensure quality, each
submission is checked by our team, before it becomes live. This Ab Initio Interview preparation PDF
was generated at Saturday 6th February, 2021

You can follow us on FaceBook for latest Jobs, Updates and other interviews material.
www.facebook.com/InterviewQuestionsAnswers.Org

Follow us on Twitter for latest Jobs and interview preparation guides.

https://twitter.com/InterviewQA

If you need any further assistance or have queries regarding this document or its material or any of
other inquiry, please do not hesitate to contact us.

Best Of Luck.

Interview Questions Answers.ORG Team

https://InterviewQuestionsAnswers.ORG/
[email protected]
 Ab Initio Interview Questions And Answers
In
te

Ab Initio Interview Questions And Answers Guide.

rv
ie
w
Q

Question - 1:
How to get DML using Utilities in UNIX?
ue

Ans:
If your source is a cobol copybook, then we have a command in unix which generates the required in Ab Initio. here it is:
cobol-to-dml.
st

View All Answers

Question - 2:
io

What is skew and skew measurement?

Ans:
ns

skew is the mesaureof data flow to each partation .

suppose i/p is comming from 4 files and size is 1 gb
1 gb= ( 100mb+200mb+300mb+5oomb)
1000mb/4= 250 mb
(100- 250 )/500= --> -150/500 == cal ur self it wil come in -ve value.
A

calclu for 200,500,300.

+ve value of skew is allways desriable.
skew is a indericet measure of graph.
ns

View All Answers

Question - 3:
w

What is the difference between a Scan component and a RollUp component?

Ans:
er

Rollup is for group by and Scan is for successive total. Basically, when we need to produce summary then we use scan. Rollup is used to aggregate data.
View All Answers
s.

Question - 4:
What is m_dump?
O

Ans:
m_dump command prints the data in a formatted way.
R

m_dump <dml> <file.dat>

View All Answers
G

Question - 5:
What is the importance of EME in abinitio?
Ans:
EME is a repository in Ab Inition and it used for checkin and checkout for graphs also maintains graph version.
View All Answers

Question - 6:
What is BRODCASTING and REPLICATE?
Ans:
Broadcast - Takes data from multiple inputs, combines it and sends it to all the output ports.
Eg - You have 2 incoming flows (This can be data parallelism or component parallelism) on Broadcast component, one with 10 records & other with 20 records.
Then on all the outgoing flows (it can be any number of flows) will have 10 + 20 = 30 records
Replicate - It replicates the data for a particular partition and send it out to multiple out ports of the component, but maintains the partition integrity.
Eg - Your incoming flow to replicate has a data parallelism level of 2. with one partition having 10 recs & other one having 20 recs. Now suppose you have 3 output

Copyright © https://InterviewQuestionsAnswers.org Page 3/8

 Ab Initio Interview Questions And Answers

flos from replicate. Then each flow will have 2 data partitions with 10 & 20 records respectively.
View All Answers

Question - 7:
In

What is local and formal parameter?

Ans:
te

Two are graph level parameters but in local you need to initialize the value at the time of declaration where as globle no need to initialize the data it will promt at the
time of running the graph for that parameter.
View All Answers
rv

Question - 8:
ie

How to run the graph without GDE?

Ans:
w

In RUN ==> Deploy >> As script , it create a .bat file at ur host directory ,and then run .bat file from Command prompt
View All Answers
Q

Question - 9:
What are differences between different GDE versions(1.10,1.11,1.12,1.13and 1.15)?
What are differences between different versions of Co-op?
ue

Ans:
1.10 is a non key version and rest are key versions.
There are lot of components added and revised at following versions.
st

View All Answers

Question - 10:
io

Can anyone give me an exaple of realtime start script in the graph?

Ans:
ns

Here is a simple example to use a start script in a graph:

In start script lets give as:
export $DT=`date '+%m%d%y'`
Now this variable DT will have today's date before the graph is run.
Now somewhere in the graph transform we can use this variable as;
A

out.process_dt::$DT;
which provides the value from the shell.
ns

View All Answers

Question - 11:
What is the syntax of m_dump command?
w

Ans:
The genaral syntax is "m_dump metadata data [action] "
er

View All Answers

s.

Question - 12:
How Does MAXCORE works?
O

Ans:
Maxcore is a value (it will be in Kb).Whne ever a component is executed it will take that much memeory we specified for execution
R
View All Answers

Question - 13:
G

What is the Difference between DML Expression and XFR Expression?

Ans:
The main difference b/w dml & xfr is that
DML represent format of the metadata.
XFR represent the tranform functions.which will contain business
rules
View All Answers

Question - 14:
I am unable to connect sever database(oracle) from GDE(db config file) local system.i set all these?
Ans:
ChalapathiFirst we can check the properties in internet options and then u can check in cmd format telenet abinitio ip_add.
View All Answers

Copyright © https://InterviewQuestionsAnswers.org Page 4/8

 Ab Initio Interview Questions And Answers

Question - 15:
What is $mpjret? Where it is used in ab-initio?
Ans:
In

You can use $mpjret in endscript like

if 0 -eq($mpjret)
then
echo "success"
te

else
mailx -s "[graphname] failed" mailid
View All Answers
rv

Question - 16:
ie

What is the latest version that is available in Ab-initio?

Ans:
w

The latest version of GDE ism1.15 AND Co>operating system is 2.14

View All Answers
Q

Question - 17:
What is AB_LOCAL expression where do you use it in ab-initio?
ue

Ans:
ablocal_expr is a parameter of itable component of Ab Initio.ABLOCAL() is replaced by the contents of ablocal_expr.Which we can make use in parallel
unloads.There are two forms of AB_LOCAL() construct, one with no arguments and one with single argument as a table name(driving table).
The use of AB_LOCAL() construct is in Some complex SQL statements contain grammar that is not recognized by the Ab Initio parser when unloading in parallel.
st

You can use the ABLOCAL() construct in this case to prevent the Input Table component from parsing the SQL (it will get passed through to the database). It also
specifies which table to use for the parallel clause.
View All Answers
io

Question - 18:
How do you convert 4-way MFS to 8-way mfs?
ns

Ans:
To convert 4 way to 8 way partition we need to change the layout in the partioning component. There will be seperate parameters for each and every type of
partioning eg. AI_MFS_HOME, AI_MFS_MEDIUM_HOME, AI_MFS_WIDE_HOME etc.
The appropriate parameter need to be selected in the component layout for the type of partioning.
A

View All Answers

ns

Question - 19:
Have you used rollup component? Describe how?
Ans:
w

If the user wants to group the records on particular field values then rollup is best way to do that. Rollup is a multi-stage transform function and it contains the
following mandatory functions.
1. initialise
er

2. rollup
3. finalise
Also need to declare one temporary variable if you want to get counts of a particular group.
s.

For each of the group, first it does call the initialise function once, followed by rollup function calls for each of the records in the group and finally calls the finalise
function once at the end of last rollup call.
View All Answers
O

Question - 20:
R

What are primary keys and foreign keys?

Ans:
G

In RDBMS the relationship between the two tables is represented as Primary key and foreign key relationship.Wheras the primary key table is the parent table and
foreignkey table is the child table.The criteria for both the tables is there should be a matching column.
View All Answers

Question - 21:
What is an outer join?
Ans:
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.
View All Answers

Question - 22:
What are Cartesian joins?
Ans:
A Cartesian join will get you a Cartesian product. A Cartesian join is when you join every row of one table to every row of another table. You can also get one by

Copyright © https://InterviewQuestionsAnswers.org Page 5/8

 Ab Initio Interview Questions And Answers

joining every row of a table to every row of itself.

View All Answers

Question - 23:
In

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

Ans:
te

Main Purpose of Stored Procedure for reduse the network trafic and all sql statement executing in cursor so speed too high.
View All Answers
rv

Question - 24:
Why might you create a stored procedure with the with recompile option?
ie

Ans:
Recompile is useful when the tables referenced by the stored proc undergoes a lot of modification/deletion/addition of data. Due to the heavy modification activity the
w

execute plan becomes outdated and hence the stored proc performance goes down. If we create the stored proc with recompile option, the sql server wont cache a plan
for this stored proc and it will be recompiled every time it is run.
View All Answers
Q

Question - 25:
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
ue

Ans:
The oracle engine uses work areas for internal processing in order to the execute sql statement is called cursor.There are two types of cursors like Implecit cursor and
Explicit cursor.Implicit cursor is using for internal processing and Explicit cursor is using for user open for data required.
st

View All Answers

Question - 26:
io

How can you force the optimizer to use a particular index?

Ans:
ns

Use hints /*+ <hint> */, these acts as directives to the optimizer
View All Answers

Question - 27:
A

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

There are several ways to do this:

1) We can move the table in the same or other tablespace and rebuild all the indexes on the table.
alter table <table_name> move <tablespace_name> this activity reclaims the defragmented space in the table
analyze table table_name compute statistics to capture the updated statistics.
w

2)Reorg could be done by taking a dump of the table, truncate the table and import the dump back into the table.
View All Answers
er

Question - 28:
Explain the difference between the truncate and delete commands?
s.

Ans:
Truncate :
O

It is a DDL command, used to delete tables or clusters. Since it is a DDL command hence it is auto commit and Rollback can't be performed. It is faster than delete.
Delete:
It is DML command, generally used to delete a record, clusters or tables. Rollback command can be performed , in order to retrieve the earlier deleted things. To
R

make deleted things permanently, "commit" command should be used.

View All Answers
G

Question - 29:
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
Ans:
There are quite a few factors that determines the approach such as what type of version control are used, what is the size of the change, what is the impact of the
change, is it a new procedure or replacing an existing and so on.
If it is a new, then just drop the wrong one
if it is a replacement then how big is the change and what will be the possible impact, depending upon you can have the entire database backed up or just create a
script for your original procedure before messing it up or you just do an ed and change the file back to original and reapply. you may rename the old procedure as old
and then work on new and so on.
few issues to keep in mind are synonyms, dependancies, grants, any job calling the procedure at the time of change and so on. In nutshell, scenario can be varied and
solution also can be varied.
View All Answers

Question - 30:
How to create repository in abinitio for stand alone system(LOCAL NT)?

Copyright © https://InterviewQuestionsAnswers.org Page 6/8

 Ab Initio Interview Questions And Answers

Ans:
If you are trying to install the Ab -Initio on stand alone machine , then it is not necessary to create the repository , While installing It creates automatically for you
under abinitio folder ( where you installing the Ab-Initio) If you are still not clear please ask your Question on the same portal .
View All Answers
In

Question - 31:
te

How would you find out whether a SQL query is using the indices you expect?
Ans:
Explain plan can be reviewed to check the execution plan of the query. This would guide if the expected indexes are used or not.
rv

View All Answers

ie

Question - 32:
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)?
w

Ans:
Take an entire database backup and restore it in different instance.
Take a statistics of all valid and invalid objects and match.
Q

Periodically refresh
View All Answers
ue

Question - 33:
How can i run the 2 GUI merge files?
st

Ans:
Do you mean by merging Gui map files in WR.If so, by merging GUI map files in GUI map editor it wont create corresponding test script.without testscript you cant
run a file.So it is impossible to run a file by merging 2 GUI map files.
io

View All Answers

Question - 34:
ns

Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
Ans:
Because every job depend upon another job for example if you first job result is successfull then another job will execute otherwise your job doesn't work.
A

View All Answers

ns

Question - 35:
What is the difference between rollup and scan?
Ans:
w

By using rollup we cant generate cumulative summary records for that we will be using scan.
View All Answers
er

Question - 36:
Describe the Grant/Revoke DDL facility and how it is implemented?
s.

Ans:
Basically,This is a part of D.B.A responsibilities GRANT means permissions for example GRANT CREATE TABLE ,CREATE VIEW AND MANY MORE .
REVOKE means cancel the grant (permissions).So,Grant or Revoke both commands depend upon D.B.A.
O

View All Answers

R

Question - 37:
When using multiple DML statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
G

Ans:
Because implicit is using for internal processing and explicit is using for user open data requied.
View All Answers

Question - 38:
What does dependency analysis mean in Ab Initio?
Ans:
Dependency analysis will answer the questions regarding datalinage.That is where does the data come from,what applications prodeuce and depend on this data etc.
We can retrieve the maximum (surrogate key) from the existing data,the by using scan or next_in_sequence/reformat we can generate further sequence for new
records.
View All Answers

Copyright © https://InterviewQuestionsAnswers.org Page 7/8

 Data Warehouse Most Popular & Related Interview Guides

1 : Warehouse Assistant Interview Questions and Answers.

2 : Data Stage Interview Questions and Answers.

3 : Informatica Data Warehousing Interview Questions and Answers.

4 : Data Warehouse Supervisor Interview Questions and Answers.

5 : Data Warehousing Interview Questions and Answers.

6 : ColdFusion Interview Questions and Answers.

7 : BO Designer Interview Questions and Answers.

8 : Actuate Interview Questions and Answers.

9 : Data Warehouse BI Interview Questions and Answers.

10 : Micro Strategy Interview Questions and Answers.

Follow us on FaceBook
www.facebook.com/InterviewQuestionsAnswers.Org

Follow us on Twitter
https://twitter.com/InterviewQA

For any inquiry please do not hesitate to contact us.

Interview Questions Answers.ORG Team

https://InterviewQuestionsAnswers.ORG/
[email protected]