Interview questions

Database Administrator (dba) interview questions – page 10

1,040 questions. Tap “Show answer” to check yourself.

  1. What are Magic Table?

  2. If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

  3. How to add source flat file header into target file?

  4. What do you worry about?

  5. Suppose we have 1 to 10 records.In router transformation wehad given two conditionA>= 5A<=5then what will be the output?

  6. Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

  7. I have a table like thisEno ename1 a2 b3 ci want to display ename and bossname from table hint boss is also an employee

  8. Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

  9. What is a surrogate key? Why we use it in a mapping? Pl give an example.

  10. What is the need of session partitioning... how it is useful in real time

  11. How to load source and targets in mapping level?

  12. What will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) errorselect Avg(salary)from TableAwhere Deptno = 'insurance'

  14. What was the toughest challenge you've ever faced?

  15. I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 versionbooks are 4.(2).Net2.0 books are 3, .Net3.5 books are 2(3)ABC1.6 books are 4, ABC2.0 books are 3.Now i want output is likeBook Count Java 6.Net 5ABC 7For this i need sql query

  16. What are your source in project and how you import in informatica? How can i explain abt this?

  17. What are the benefits of using stored procedures over sqlstatements?

  18. What would you say to your boss if he's crazy about an idea, but you think it stinks

  19. What is different between union and minus?

  20. WHAT IS FACT LESS FACT TABLE?

  21. How do you keep track of things you need to do?

  22. Tell me some dimension tables names in banking domaininformatica project(dont tell like depends on project, tellme names of dimension and fact table names in your project)?

  23. From where you extract the data, how you did it into informatica? explain...

  24. Difference between a HAVING CLAUSE and a WHERE CLAUSE?

  25. For informatica developer, in real time, normally how much we use sql and plsql?

  27. How do u call in & out parameters for stored procedures?

  28. There is a big table with "n" of rows and 40 + columns .Itdoesn't have primary key.How do you select the primary key.In other words how do you get the duplicate records.

  29. In bankingdomain projects how many facttables are there?

  30. What is JOIN? Give example & types of join?

  31. How to find the second highest salary from emp table?

  32. What is Aggregate Functions?

Companies that ask Database Administrator (dba) questions

Bending Spoons Interview guide Spiralyze Interview guide Winman Software India Interview guide Namecheap Interview guide Softsquare Interview guide E-Con Systems Interview guide