Abinitio Interview Questions

  1. What is a generic graph?
  2. What is lookup template?
  3. What is Compressed Lookup?
  4. How Does MAXCORE works?
  5. Have you worked with packages?
  6. How to run the graph without GDE?
  7. What is meant by fancing in abinitio?
  8. What are local and formal parameter?
  9. What about DML changes dynamically?
  10. How will you create a multifile in UNIX?
  11. How to get DML using Utilities in UNIX?
  12. What is data mapping and data modelling?
  13. How do you add default rules in transformer?
  14. How do you connect EME to Abinitio Server?
  15. How to Create Surrogate Key using Ab Initio?
  16. How to take the input data from an excel sheet?
  17. How to create tags? What are the contents in it?
  18. What is the difference between rollup and scan?
  19. What is the role manager details in abinitio tool?
  20. What does dependency analysis mean in Ab Initio?
  21. How will you test a dbc file from command prompt?
  22. Explain the differences between API and utility mode?
  23. How can we implement refrential integrity in Abinitio?
  24. How can you force the optimizer to use a particular index?
  25. What is the difference between a DB config and a CFG file?
  26. Have you ever encountered an error called “depth not equal”?
  27. What do you mean by profile in Abinitio and what does it contains?
  28. Can anyone please explain the environment variables with example?
  29. What is the function you would use to transfer a string into a decimal?
  30. Why might you create a stored procedure with the ‘with recompile’ option?
  31. What is the difference between a Scan component and a RollUp component?
  32. How to write conditional DML if the file has huge amount of data? Give me an example?
  33. How to debug your graph? If we have a check point at phase break and if we want to see only a perticular record through that watcher how will u go?
  34. What is the difference between sandbox and EME, can we perform checkin and checkout through sandbox/ Can anybody explain checkin and checkout?
  35. What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summirize group of data record. then where we will use aggregation?