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 the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.

0 Answers  


Describe the effect of the "checkpoint" t-sql statement?

1 Answers  


I am having 10 records in i/p file,and i want to load only one record at a time to the output file.Then how can i do it?

2 Answers   IBM,


what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?

0 Answers  


We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam Bangalore Abhinav In output we need 2 files one file for london and second file for Bangalore.How to acheve this?

4 Answers   IMS, TCS,






what is SSH?What is the differences between the SSH,SSH1,SSH2?

2 Answers  


What is rollup component?

0 Answers  


Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

0 Answers  


Describe the grant/revoke ddl facility and how it is implemented?

0 Answers  


What is a partition and what are the different types of partition components in abinitio?

0 Answers  


What is max core value ? what is the use of it?

2 Answers   JPMorgan Chase, Wipro,


what does layout means in terms of Ab Initio?

3 Answers  


Categories