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 |
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.
Describe the effect of the "checkpoint" t-sql statement?
I am having 10 records in i/p file,and i want to load only one record at a time to the output file.Then how can i do it?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam Bangalore Abhinav In output we need 2 files one file for london and second file for Bangalore.How to acheve this?
what is SSH?What is the differences between the SSH,SSH1,SSH2?
What is rollup component?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
Describe the grant/revoke ddl facility and how it is implemented?
What is a partition and what are the different types of partition components in abinitio?
What is max core value ? what is the use of it?
2 Answers JPMorgan Chase, Wipro,
what does layout means in terms of Ab Initio?