Interested to Buy Any Domain ? << Click Here >> for more details...
Can you use scan to generate sequence number ? How to use in abinitio graph?
- 2 Answers
- 9006 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 a deadlock and how it occurs?
Need Ab-Initio Material - Harini
Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump
What do you mean by the term data warehousing?
You can ask about - meta pivot, leading records, read & write multiple files component ? How to use in abinitio graph?
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
Explain how abinitio eme is segregated?
What is local and formal parameter?
What is data mapping and data modelling?
wt is meant by repartioning in howmany ways it can be done.
What is brodcasting and replicate?
What are the functions of the replicate and dedup component?
Teradata 
