Can you use scan to generate sequence number ? How to use in abinitio graph?
- 2 Answers
- 8349 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 |
What is the function that transfers a string into a decimal?
Please some body send me Ab Initio material in my mail ... sitakanta2009@gmail.com Thanks in Advance!!!
Which component breaks the pipe line parallelism in graph?
Can anyone give me an exaple of realtime start script in the graph?
What is the purpose of having stored procedures in a database?
You can ask about - meta pivot, leading records, read & write multiple files component ? How to use in abinitio graph?
What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.
Explain what is sort component in abinitio?
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.
Can any body give the PDL with example?
How scientific data processing is different from commercial data processing?
What are the Graph parameter?
Teradata 
