Can you use scan to generate sequence number ? How to use in abinitio graph?
Answers were Sorted based on User's Feedback
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 |
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 |
Where $mpjret is used in ab-initio?
What are the primary keys and foreign keys?
What is the difference between a utility and api in a RUN SQL component
What is the difference between rollup and scan?
What is AB_LOCAL expression where do you use it in ab- initio?
How do we handle if DML changing dynamicaly?
5 Answers GE, HP, IBM, Mannar Company,
Mention what dedup-component and replicate component does?
What is common among data validity and data integrity?
What is standard environment ? How to use in abinitio graph?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
Explain batch processing in ab initio?
difference betwween check point and phase?