Can you use scan to generate sequence number ? How to use in abinitio graph?
- 2 Answers
- 7673 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 transaction file different from that of a sort file?
. How can you run a graph continuously without using continuous components ?
What is regex (lookup)? When you should use it?
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
. How we can remove temp files of a failed job if .rec is not available
What is abinitio?
How to compare two dmls in abinitio
What is is a data flow graph?
hello, tell me the function which removes spaces from decimal field?
How to run the graph without GDE?
Mention what are the different types of parallelism used in abinitio?
What is AB_LOCAL expression where do you use it in ab- initio?
Teradata 
