Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Ab Initio Interview Questions

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

1 Answers  


Explain the difference between the truncate and delete commands?

0 Answers  


explain checkin and checkout?

0 Answers  


Layout - L1*, L1 - What is the difference ? How to use in abinitio graph?

1 Answers   IBM, TCL,


How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

0 Answers  






What is a data processing cycle and what is its significance?

0 Answers  


What is the difference between check point and phase?

0 Answers  


How you can create cross joined output using join component ?

3 Answers  


State the working process of decimal_strip function?

0 Answers  


Difference between output_index and output_indexes in reformat

0 Answers  


what is SSH?What is the differences between the SSH,SSH1,SSH2?

2 Answers  


. How can you run a graph continuously without using continuous components ?

3 Answers   TCL,


Categories