How to Create Surrogate Key using Ab Initio?

Answer Posted / prashant

by using next_in_sequence() function in transform.

Is This Answer Correct ?    18 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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?

4143


What kind of layouts does abinitio support?

888


Can sorting and storing be done through single software or you need different for these approaches?

836


What happens when we provide null key to sort, merge and pbks in Abinitio ?

1275


what is the output when -1 is put in select_expr of FBE?

1148


Explain data flow graph with an example?

825


In abinitio, what types of parallelism are used?

783


How is the partitioning with key different from round robin partition?

911


Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?

833


Have you used rollup component? Describe how.

835


What exactly do you know about the typical data analysis?

793


Explain how abinitio eme is segregated?

1179


Why might you create a stored procedure with the with recompile option?

843


What is a rollup component?

816


Mention what is the syntax for m_dump in abinitio?

1202