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

After completion of graph what is the next process to perform? who will perform the later process?

1 Answers  


How do we extract data from client machine?

1 Answers  


Have you eveer encountered an error called "depth not equal"?

2 Answers  


Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

0 Answers  


What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

0 Answers  






Have you ever encountered an error called “depth not equal”?

0 Answers  


Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

0 Answers  


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

9 Answers   IBM, TCS,


What are the different types of partition components in abinitio?

0 Answers  


Why do you think data processing is important?

0 Answers  


I have a DML in my local system the location is E:/u/home/khaleel/dml how to convert this path to $DML?

1 Answers  


how to prepare scd2 in abinitio

1 Answers   CTS,


Categories