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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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)?

881


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

1245


Mention what information does a .dbc file extension provides to connect to the database?

941


How can I run the 2 gui merge files?

895


What is rollup component?

882


what is the difference between i)public ii)private iii)common and client projects?

1908


What are the benefits of data processing according to you?

908


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

1140


What are the different types of parallelism used in abinitio?

816


I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

888


How can we increase the loading performance of oracle table in AbInitio?

851


How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

833


What are the Graph parameter?

897


We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?

1019


Can anyone give me an example of realtime start script in the graph?

892