How would you find out whether a sql query is using the indices you expect?


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

Post New Answer

More Ab Initio Interview Questions

what is extension list in abinitio?

1 Answers  


What will be the output of using partition by Round-Robin after the partiton by key in ab initio?

1 Answers  


what is the output when -1 is put in select_expr of FBE?

0 Answers  


How data is processed and what are the fundamentals of this approach?

0 Answers  


Need Ab-Initio Material - Harini

7 Answers  






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  


Code check-in and check-out commands in AbInitio

0 Answers  


) Diff.between Output index and Output indexes?

4 Answers   TCL, TCS,


How can you import XML repositories exported from different tools like ODI

0 Answers  


what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?

0 Answers  


What is rollup component?

0 Answers  


Hello, I need help on passing parameter to Oracle Stored Procedure.I am a oracle DBA,need to use some graphs. I need help to pass date parameter with format YYYYMMDD from Ab Initio to Oracle STored Procedure.How to do that please explain me...

1 Answers  


Categories