Just Crack Interview

DB Architecture interview questions – page 2

405 questions. Tap “Show answer” to check yourself.

Advertisement

  1. Write any data structure program (stack implementation)

  2. What are triggers in DB?

  3. What is Transaction(RDBMS)

  4. Tell me how many tables used in Ur project and how many facttables and dimension tablesused in ur project

  5. When U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

  6. How can or from where we can get reference data in scd type2 implementation?

  7. Hi I have scenario like thiss/r table T/r tableename,sal empno,ename,salvijay,2000 1 , vijay, 2000kumar,3000 2 ,kumar , 3000ravi ,4000 3 ,ravi , 4000How can i get target table like that without usingTransformer stage?

  8. What is Galaxy schema??

  9. Why we require dwh in particular projects?

  10. How can we display records in single datagrid using two datasets in different place?

  11. Hi This is Vijay,How can your remove the duplicates in sequential File?

  12. What is metadata?

  13. Advertisement

  14. Is it possible to perform data validations in the database?

  15. WHAT ARE MAIN DIFFERENCE BETWEEN DCS AND SCADA?

  16. What is denormalization and when would you go for it?

  17. What is exact difference between Parallel Jobs and server Jobs..

  18. Explain the differences between api and utility mode?

  19. Describe the ?Grant/Revoke? DDL facility and how it is implemented.

  20. What are differences between different GDE versions(1.10,1.11,1.12,1.13and 1.15)?What are differences between different versions of Co-op?

  21. What is AB_LOCAL expression where do you use it in ab-initio?

  22. How will you test a dbc file from command prompt ??

  23. Explain the concepts and capabilities of OLAP.

  24. What do you mean by .profile in Abinitio and what does it contains?

  25. How to Improve Performance of graphs in Ab initio?Give some examples or tips.

  26. Advertisement

  27. What is the importance of EME in abinitio?

  28. What is the difference between .dbc and .cfg file?

  29. How do I control what happens when I start Word?

  30. What are the different versions and releases of ABinitio (GDE and Co-op version)

  31. How do I change the format of the number symbols in a numbered list without changing the rest of the text?

  32. How to handle if DML changes dynamically in abinitio

Advertisement
Advertisement