ETL TESTING CONCEPTS

 ETL TESTING CONCEPTS

1.         Explain about your project?

2.         Explain about your project architecture?

3.         Explain about your roles and responsibilities?

4.         How many tables you are maintaining in your project, for how many tables you did testing?

5.         What all are the challenges you faced while doing ETL testing in your project?

6.         Tell me different scenarios which you validated in your project?

7.         How you will validate data for Incremental and Initial load data?

8.         Which techniques you followed while doing ETL testing?

9.         Tell me different test cases for new table?

10.       How you will validate data for Enhancement work?

11.       How to validate data in target table if source table is present in different database?

12.       How to validate data for Flat file to Table?

13.       How much amount data maintain in your project Warehouse?

14.       Tell me about your client details and explain their business?

15.       How to find out duplicate records in a table?

16.       Why we need to perform Source minus Target and Target Minus Source?

17.       Explain any complex query which you have written while doing testing?

18.       What is Entry Criteria and Exit Criteria for your project?

19.       What all are your responsibilities in you project?

20.       How can you execute more number of test cases with one day span of time, on what basis you will pick test case?

21.       What all are different tools you used in your project?

22.       What is data completeness check, what kind of checks you perform in this?

23.       Defect life cycle?

24.       What are different ETL testing techniques?

25.       What all are different defects which you have raised in your project?

26.       Explain any one of the defect which you have raised recently?

27.       Tell me about yourself?

28.       Tell me about your professional experience?

29.       What all are input and output documents in your project?

30.       What all are the tools you have used in your project?

31.       How to validate data from text file to table?

32.       Explain about architecture of your project?

TERADATA CONCEPTS

TERADATA CONCEPTS

1.         What is Spool Space in Teradata?

2.         What is Fallback?

3.         Explain Teradata Architecture

4.         Write a query to delete duplicate rows?

5.         Diff b/w PI and PK.

6.         What is Full Outer Join? Give a scenario where it can be used?

7.         Diff b/w left outer and right outer join.

8.         What is PPI?

9.         How does compress work.

10.       Diff b/w Teradata and Oracle.

11.       What is spool space? Does it impact other users?

12.       What is multiset

13.       What is derived query

14.       Difference between derived table and volatile table

15.       How will teradata decide which row will have to be placed where? ans- Hashing Algorithm.

16.       What is Set and MultiSet table?

17.       What is meant by Skew? Explain.

18.       What is volatile table?

19.       What are the other kinds of tables.

20.       What is the difference between Volatile and Global Temp table?

21.       How to select first N Records in Teradata?

22.       What is the difference between Sub-Query & Co-Related Sub-Query?

23.       Is Like comparison case-sensitive in Teradata?

24.       Difference between Inner join and outer join?

25.       How to find duplicates in a table?

26.       How do you see a DDL for an existing table?

27.       Which is more efficient GROUP BY or DISTINCT to find duplicates?

28.       Syntax for CASE WHEN statement?

29.       How to handle nulls in Teradata???

30.       How to find average sal without using avg function????

31.       What all are different protection techniques in teradta..?

32.       What are salient features of Teradata..?

33.       How data will be distributed in teradta..?

34.       How to find a particular table details in teradata..?

35.       How to find a particular column details in teradata..?

36.       How to use Rank function and Row number functions..

37.       How to use partition by concept in Teradata..?

38.       How to tune queries in Terdata..?

39.       How to find top 3 salaries in a particular table?

40.       How to use String functions substr(),Like operarator?

41.       Difference between Where, Having and Qualify?

42.       SQL Concepts with all functions and operators?

ETL CONCEPTS (INFORMATICA)

 ETL CONCEPTS (INFORMATICA)

1.   Why we use lookup transformations?

2.   Where should U place the flat file to import the flat file definition to the designer?

3.   To provide support for Mainframes source data, which files r used as a source definitions?

4.   Which transformation should u need while using the COBOL sources as source definitions?

5.   How can U create or import flat file definition in to the warehouse designer?

6.   What is a transformation?

7.   What are the designer tools for creating transformations?

8.   What are the active and passive transformations?

9.   How can U improve session performance in aggregator transformation?

10. What are the difference between joiner transformation and source qualifier transformation?

11. What are the join types in joiner transformation?

12. Why use the lookup transformation?

13. What are the types of lookup?

14. Which transformation should we use to normalize the COBOL and relational sources?

15. What is the Router transformation?

16. What are the types of groups in Router transformation?

17. What is source qualifier transformation?

18. What are the tasks that source qualifier performs?

19. What is Data driven?

20. What r the types of metadata that stores in repository?

21. If a session fails after loading of 10,000 records in to the target. How can u load the records from?

22. Explain the informatica Architecture in detail

23.       Discuss which is better among incremental load, Normal and Bulk load

24.       What is difference between IIF and DECODE Function

25.       What is rank transformation? Where can we use this transformation?

26.       What is surrogate key? In your project in which situation u has used? Explain with example?

27.       Why sorter transformation is an active transformation?

28.       How can you improve the performance of Aggregate transformation?

29.       What are the common errors that you face daily?

30.       What is Metadata, where it will store in Informatica?

31.       What is Data acquisition process?

32.       What is GUI and Code based ETL tools?

33.       Which transformation we can use for data scrubbing?

34.       Which transformation we can use for data cleansing?

DATA WAREHOUSING CONCEPTS

DATA WAREHOUSING CONCEPTS

1.         What is a data-warehouse?

2.         What is Dimensional Modeling?

3.         What is the Difference between OLTP and OLAP?

4.         What is Fact table and dimension table?

5.         What is a level of Granularity of a fact table? What does this signify?

6.         What are slowly changing dimensions? What are SCD1, SCD2 and SCD3?

7.         What are types of facts? (Inventory, Account balances in bank)

8.         What are conformed dimensions?

9.         Discuss the advantages & Disadvantages of star & snowflake schema?

10.       What is a junk dimension?

11.       What are the difference between view and materialized view?

12.       Compare Data Warehousing Top-Down approach with Bottom-up approach

13.       What is fact less fact table?

14.       What is the architecture of any Data warehousing project? What is the flow?

15.       Where we use Star Schema & where Snowflake?

16.       Tell me what would the size of your warehouse project?

17.       What is surrogate key? Where we use it explain with examples

18.       Can a dimension table contain numeric values?

19.       What is Difference between E-R Modeling and Dimensional Modeling?

20.       Why fact table is in normal form?

21.       What is the role of surrogate keys in data warehouse and how will u generate them?

22.       What is the main difference between Inmon and Kimball philosophies of data warehousing?

23.       How do you connect two fact tables? Is it possible?

24.       What is data cleansing? How is it done?

25.       Difference between DWH and ODS?