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

Ab Initio Interview Questions

Questions Answers Views Company eMail

What does dependency analysis mean in Ab Initio?

Syntel,

5 29242

How to Create Surrogate Key using Ab Initio?

IBM,

6 32408

What is .abinitiorc and What it contain?

CSC,

3 38172

What are the components new in 2.14 compared to 1.8 and State the usage of the components?

2176

Describe the effect of the "checkpoint" t-sql statement?

1 5314

Describe what the SQL Server tempdb and tlog files are used for?

2289

Why might the optimizer use a table scan when an index is available?

2263

How might you quantitatively measure an improvement made to a query?

2 9350

What is the difference between sandbox and EME, can we perform checkin and checkout through sandbox?

JPMorgan Chase, Syntel,

5 34013

what does layout means in terms of Ab Initio?

3 26629

How do we handle if DML changing dynamicaly?

GE, HP, IBM, Mannar Company,

5 32827

How can we test the abintio manually and automation?

JP Group,

1 6960

How will you use EME for view or publish metadata reports using EME?

1 5768

How to Improve Performance of graphs in Ab initio?

TCS, Wells Fargo,

2 29593

what is the difference between .dbc and .cfg file?

Cap Gemini,

3 20490

Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

What is a cursor? Within a cursor, how would you update fields on the row just fetched?

1128

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 ?

1314

What is the syntax for m_dump in abinitio?

1586

What is abinitio?

1132

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2223

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?

4345

What is the difference between formal and export parameter? Export at what secenario we are going to use?

2586

What is a partition and what are the different types of partition components in abinitio?

1223

How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?

2071

What are the Graph parameter?

1117

How do you improve the performance of a graph?

1090

What are the different types of parallelism used in abinitio?

1059

How do you truncate a table?

1126

How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

1960

What is the difference between sandbox and EME?

1216

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