Ab Initio Interview Questions
Questions Answers Views Company eMail

What is the difference between a utility and api in a RUN SQL component

Accenture,

1 6853

Describe step by step the process of creating tag and savefile for migration

TCS,

1 14525

i have input like this TABA 1 TABA 2 TABA 3 TABA 4 TABB 7 TABB 8 TABC 1 TABC 2 TABC 5 OUT PUT NAME COL1 COL2 COL3 COL4 TABA 1 2 3 4 TABB 7 8 TABC 1 2 5

1167

How to compare two dmls in abinitio

1198

explain the environment varaibles with example?

629

Have you used rollup component? Describe how.

664

What is the difference between sandbox and EME?

684

What parallelisms does Abinitio support?

730

What is a deadlock and how it occurs?

669

How do you truncate a table?

688

What is the difference between rollup and scan?

1253

State the relation between EME, GDE and Co-operating system?

676

Explain the methods to improve performance of a graph?

674

How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?

721

Describe the Evaluation of Parameters order.

1 1070


Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

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?

3899


How co>operating system integrates with legacy codes?

617


What do you mean by the term data warehousing? Is it different from data mining?

677


How to compare two dmls in abinitio

1198


Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999

463






what is the use of catlog or catlogfile?

1921


Explain the ab initio etl tool in high level?

676


Do you think effective communication is necessary for data processing?

731


how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio

1312


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

5034


What are the kinds of layouts does ab initio supports?

578


We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

887


Where $mpjret is used in ab-initio?

680


What is the core of co> operating system?

639


Mention what dedup-component and replicate component does?

618