Can you use scan to generate sequence number ? How to use in abinitio graph?
- 2 Answers
- 8396 Views
- IBM, TCL, I also Faced
- E-Mail Answers
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 |
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
Have you used the rollup component? Describe how?
Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?
What is sandbox?
List out some of the air commands used in abintio?
What is meta programming ? Can you generate xfr dynamically? How to use in abinitio graph?
name the air commands in ab initio?
What is the significance of ‘mp run’ command ?
How can we increase the loading performance of oracle table in AbInitio?
What would be the next step after collecting the data?
. What is flow buffering ? How it reduces the chances of having deadlock ?
) How can you count the total no .of records in the specified partition in the Multifile?
Teradata 
