How to Create Surrogate Key using Ab Initio?
- 6 Answers
- 29434 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prashant
by using next_in_sequence() function in transform.
| Is This Answer Correct ? | 18 Yes | 2 No |
Answer / sudheer
by using scan component also we can generate surrogate key
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / sivasankar pasupuleti
we creating surrogate key in abinitio by using the following
ways:
1.by using assign new key component
2.by using scan component
3.by using next_in_sequence()
| Is This Answer Correct ? | 10 Yes | 2 No |
Answer / raju mortale
by using next_in_sequence() function in transform
| Is This Answer Correct ? | 2 Yes | 0 No |
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
What are the differences between different versions of co-op?
What exactly do you understand with the term data processing and businesses can trust this approach?
What are the steps to create a repository in ab initio?
What is the syntax for m_dump in abinitio?
What metadata importer can do in ab initio?
What is sandbox?
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)?
what is difference between fuse and join? Explain in detail? In which scenario we will use them?
What are the primary keys and foreign keys?
How do you convert 4-way mfs to 8-way mfs?
What parallelisms does Abinitio support?
Teradata 
