How to Create Surrogate Key using Ab Initio?

Answer Posted / amansharma3737@gmail.com

By using next_in_sequence()

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by a transaction file?

671


What do you mean by a transaction file and how it is different from that of a sort file?

629


What is the purpose of having stored procedures in a database?

623


Tell us about the architecture of abinitio.

648


What do you mean by the overflow errors?

740






Have you used the rollup component? Describe how?

631


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

612


explain the environment varaibles with example?

623


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

7975


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

1481


how to insert/update a csv file by comparing it with another csv file?

1652


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

1292


What are the primary keys and foreign keys?

546


What is the difference between sandbox and EME?

679


What is a partition?

714