Ab Initio Interview Questions
Questions Answers Views Company eMail

What does dependency analysis mean in Ab Initio?

Syntel,

5 16818

How to Create Surrogate Key using Ab Initio?

IBM,

6 18317

What is .abinitiorc and What it contain?

CSC,

3 22094




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

884

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

1 1391

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

1019

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

910

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

2 5367




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

Syntel, JPMorgan Chase,

5 20450

what does layout means in terms of Ab Initio?

3 16807

How do we handle if DML changing dynamicaly?

HP, GE, IBM, Mannar Company,

5 18894

How can we test the abintio manually and automation?

JP Group,

1 2662

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

1 2019

How to Improve Performance of graphs in Ab initio?

TCS, Wells Fargo,

2 17734

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

Cap Gemini,

3 10266


Post New Ab Initio Questions






Un-Answered Questions { Ab Initio }

what is the difference between i)public ii)private iii)common and client projects?

794


Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com

1011


Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use

2249


You can ask about different vector functions. How to use in abinitio graph?

3286


difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

1310






What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?

987


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?

2399


. What is dynamic lookup ?

1320


what is the project environment(for each project the environment is same or different to different project)?

766


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

910


When we should use 'jobid' for commit table (Output table component??

4886


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

1265


To which project that prefix will set is to private project or public project or both?how and where to set?

622


How can you import XML repositories exported from different tools like ODI

2141


How can you export a component’s internal parameters ?

1168