When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
What do you mean by the overflow errors?
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
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
What do you mean by data sorting?
If m loading a file of 1 million records.and the graph fails after loading 10,000 records. In this case if we use rollback command then what will happen?
How data is processed and what are the fundamentals of this approach?
How can you connect eme to abinitio server?
How can you achieve scan using reformat ?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
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?
What is the difference between Generate Records Component and Create Data Component?