How you can generate surrogate key? How to use in abinitio graph?

Answers were Sorted based on User's Feedback



How you can generate surrogate key? How to use in abinitio graph?..

Answer / kv

you can also make use of assign key component.

Is This Answer Correct ?    2 Yes 0 No

How you can generate surrogate key? How to use in abinitio graph?..

Answer / archana reddy

next_in_sequence() -serial files (next_in_sequence()*number of partitions)+this partition() -multi files

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More Ab Initio Interview Questions

Have you eveer encountered an error called "depth not equal"?

2 Answers  


Have you used the rollup component? Describe how?

0 Answers  


difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

0 Answers   CTS,


Describe the Evaluation of Parameters order.

1 Answers  


Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

0 Answers  






Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

0 Answers  


How you can run a component for certain conditions ?

1 Answers  


Have you used rollup component? Describe how.

0 Answers  


Why might the optimizer use a table scan when an index is available?

0 Answers  


How to Improve Performance of graphs in Ab initio?

2 Answers   TCS, Wells Fargo,


When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?

0 Answers   IBM, TCL,


Which Ab initio version has Hadoop connector ? and what is the latest GDE version available ?

1 Answers   Infosys, TCS,


Categories