Just Crack Interview

Etl interview questions

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

Advertisement

  1. Difference between ETL and data mining, Types of Fact Table according to dimensional value, What is Factless Fact Table, Types of Dimension.

  2. Describe how you would ensure that database object definitions (Tables, Indices, Constraints, Triggers, Users, Logins, Connection Options, and Server Options etc) are consistent and repeatable between multiple database instances (i.e.: a test and producti

  3. IN A ROOM THERE IS ONE BULB OUTSIDE F THE ROOM THERE ARE THREE SWITCHES ONLY ONE SWITCH IS CONNECTED THE BULB.YOU ARE ALLOWED TO STAND NEAR THE SWITCH FOR 5 MINUTES WHAT EVER YOU DO THE SWITCH.AFTER 5 MINUTES ENTER THE ROOM AND TO SAY WHICH IS THE CORRECT

  4. What is a mapping, session, worklet, workflow, mapplet?

  5. What is the difference between etl tool and olap tools

  6. What are the various methods of getting incremental records or delta records from the source systems?

  7. Where do we use connected and un connected lookups

  8. I'am new to SAS, can anybody explain the process of extracting data from source systems,storing in ODS and how data modelling is done.

  9. What is the difference between Power Center & Power Mart?

  10. Where do we use semi and non additive facts

  11. What is the metadata extension?

  12. What are parameter files ? Where do we use them?

  13. Advertisement

  14. What is partitioning? What are the types of partitioning?

  15. What are the various transformation available?

  16. Do we need an ETL tool? When do we go for the tools in the market?

  17. Compare ETL & Manual development?

  18. can u join flat file and database in datastage?how?

  19. How can i edit the XML target, are there anyways apart from the editing the XSD file.Can i directly edit the XML directly in Informatica designer.

  20. What is a three tier data warehouse?

  21. What are the various tools? - Name a few.

  22. What is ETL process ?How many steps ETL contains explain with example?

  23. How do we extract SAP data Using Informatica? What is ABAP? What are IDOCS?

  24. What is ODS (operation data source)

  25. What is latest version of Power Center / Power Mart?

  26. Advertisement

  27. How we use NLS in Datastage ? what advantages in that ?

  28. When do we Analyze the tables? How do we do it?

  29. How to fine tune the mappings?

  30. What are active transformation / Passive transformations?

  31. What is Full load & Incremental or Refresh load?

  32. What are the different versions of Informatica?

Advertisement
Advertisement