Answers were Sorted based on User's Feedback
Answer / ananya
You can use assign_keys component
|Is This Answer Correct ?||18 Yes||0 No|
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||2 No|
Answer / sivasankar pasupuleti
we creating surrogate key in abinitio by using the following
1.by using assign new key component
2.by using scan component
3.by using next_in_sequence()
|Is This Answer Correct ?||9 Yes||2 No|
Answer / raju mortale
by using next_in_sequence() function in transform
|Is This Answer Correct ?||1 Yes||0 No|
What is rollup component?
One file contains header,body,trailer records and header in a single row as well as trailer too.How to segregate these header,trailer and body records and once it gets segregated,i want to make the body data in reverse i.e if i have 10 body records,the 10th record should be the first record,9th record should be the second line,etc..
What is the significance of ‘mp run’ command ?
How would you find out whether a sql query is using the indices you expect?
How do you improve the performance of a graph?
What is abinitio?
the inputs are 10,20,30,40,50 but the output was comes 0 records,the graph was failed what is bad situation?
What mpjret contains ? How to use in abinitio graph?
What is the difference between a utility and api in a RUN SQL component
What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?
What do you mean by a transaction file and how it is different from that of a sort file?
What are the Graph parameter?