Most Important INTERVIEW QUESTIONS

• what are the Partition component tell me in detail
• what is the purpose of  overide key parameter in the join component ?
• what is difference b/w join and merge..components ?
• If table A contains 10 and table B contains 0 record ,what is the o/p total number of records if we do cross join
• Wat is genaric graph?
• how will write the code for reformat compotent as a generic graph?
• what is lookup template
• what is compressed lookup.
• Wat is AB unit ?
• what are the grap level parameters? how u define  in u r project
• what are the measure of the fact table?
• I have 2 way partition flow file we need to generate surrogate key for out file How to generate it
• What is wrapper script.
• Tell about the rollup and its parameters
• what is the diff b/e the rollup and scan
• What is the purpose of m_rollup
• what is chk-in and chek-out where does we do it and how many ways.
• What is pstes.
• Tell the most used air_commands in your project.
• write any two sample scripts previously used in project

• Tell me about yourself and your current project?
• What are the components you have used in your graph?
• Explain the multi file, multi file system and multi file directory?
• What are m_commands you have used?
• What is the difference between m_dump and m_expand?
• How do u connect to the database?
• How do u test whether your dbc file is correct or not?
• How do you change 2-way to 4-way multifile?
• Have you worked with EME if yes, tell me what all the air commands you have used are?
• How do you find out the version of EME?
• Tell me the difference between api and utility?
• What is output_index and output_indexes?
• If I give key null in join component will the component work?
• What are the parameters in join component?
• What is override key parameter in join component?
• What is layout?
• What are the errors you have faced?
• When will you get the fatal error?
• What are the UNIX commands you have used?
• What is SED and tell me one example where you have used in your project?
• What AWK tell me one example?
• How do you find out and delete the files which were created 30 days before?
• How do you find out the nth highest salary in the table?
• What is skew?
• Which parameters first resolved whether graph level or sandbox level?
• How do you connect to oracle?
• If you select in-memory – input need not be sorted in join component how it will work?

• which database you are using
• What is the difference between .dbc and .cfg file
• What is a Surrogate Key. How do you Create it.
• What is conditional dml.
• What is Lookup file
• Tell me briefly about the parallelism.
• Which components cannot support the pipeline parallelism
• What are the continuous components
• what is the diff b/w scan and rollup.
• What is .pset
• tell me the importance of EME in abinitio
• How you run the graph in Unix environment
• Tell me about air commands
• What is AB_LOCAL where you will you it.
• How to schedule graph's in abinitio.
• How you open the multifile in unix.
• What is the diff b/w sandbox and EME
• What is chek-in and chek-out from gde and unix.
• I have some 100 records in that fetch out the records related to word delhi from the line of 56 to 89.
• How you improve the performance of previous build graphs.
• Tell me about version controlling in abinitio

• What is your Role in current Project
• Explain the Flow of your current project
• What the Database using for your project
• How you connect to your Database
• What are the permissions you have to access Database
• What the .dbc file contains.
• What is the difference b/w Truncate and delete.
• How you Take data from flat files.
• What the requirement document contains exactly.
• How to prepare analysis document and What it contains.
• How assign keys components can work.
• How you get history file.What are primary keys and foreign key
• Explain Reformat with parameters and how it acts in Real-time.
• Functionality of Roll-up and how to filter the records in it.
• I have 100 records in which 10 records need to get aggregated ,left the rest.How will you handle.
• What are the components you worked most.
• What is view.
• Create a view using table and i need only 100 rows in my view instead of all records.
• What is m_dump command.
• How you execute the script from GDE.
• What is wrapper script.
• How many graph's you developed up-to here.

• which version you are using.
• what are the components you are working
• what is the scheduling tool you have used.
• Tell me about join .
• What are the parameters of join explain all.
• what is semi-join.
• what are cartesian joins.
• what is lookup.
• what the partition components you worked
• What is the difference between merge and concatenate.
• what is the diff b/w scan and role-up.
• How will you test a dbc file from command prompt.
• What is generic graph.
• what is wrapper script.
• What are m_commands.
• What is the purpose of m_rollup.
• How to write conditional dml if the file has huge amount of data.
• how do you convert4-way mfs to 16-way mfs.
• how would you do performance tuning for already builted graph.
• Tell the sed and awk commands with some suitable examples.
• write two sample scripts previously you wrote.