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?