Can you use scan to generate sequence number ? How to use in abinitio graph?

Answers were Sorted based on User's Feedback



Can you use scan to generate sequence number ? How to use in abinitio graph?..

Answer / saba

In the scan component,you can declare a variable for the sequence number generation.Initialize this variable with 0 and store it in another variable. Then increase the new variable by 1,suppose count is the new variable do it like count = count+1 and finally u can use this count variable or else you can store it in another field..it depends upon ur dml.

Is This Answer Correct ?    3 Yes 0 No

Can you use scan to generate sequence number ? How to use in abinitio graph?..

Answer / satya

yes.. we can use scan by adding a another field in the output dml. And map it with next_in_sequence().

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Ab Initio Interview Questions

what is meant by fancing in abinitio ?

3 Answers  


What is abinitio?

1 Answers  


from a graph how to select only second record always in scan?

3 Answers   IBM,


One file contains header,body,trailer records and header in a single row as well as trailer too.How to segregate these header,trailer and body records and once it gets segregated,i want to make the body data in reverse i.e if i have 10 body records,the 10th record should be the first record,9th record should be the second line,etc..

4 Answers   TCS,


How can you find the 2nd Highest salary in a file department wise in abinitio?

9 Answers   IBM, TCS,


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

1 Answers  


What mpjret contains ? How to use in abinitio graph?

2 Answers   IBM, TCL,


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

2 Answers   HCL,


What do you mean by the overflow errors?

1 Answers  


What is the role of co-operating system in abinitio?

1 Answers  


11. What is the use of allocate()?

1 Answers   TCL,


Explain how you can run a graph infinitely in ab initio?

1 Answers  


Categories