1. What are active transformation / Passive transformations?

2. Explain the ETL process diagram from source to final DWH using multi sources and diagram?

3. what is the effect of the OPTIONS statement ERRORS=1

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

5. What is Informatica Metadata and where is it stored?

6. In What scenario ETL coding is preferred than Database level SQL, PL/SQL coding? What is the methodology and process followed for ETL testing in Data warehouse environment? Develop a mapping to extract the employee drawing maximum salary where deptno = department drawing... If LKP on target table is taken, can we update the rows without update strategy transformation? How you capture changes in data if the source system does not have option of storing date/time field... What is the Difference b

7. What is the methodology and process followed for ETL testing in Data warehouse environment?


8. Develop a mapping to extract the employee drawing maximum salary where deptno = department drawing maximum sum(salary) group by dept.sources are cobol files / flat files.

9. What is a staging area? Do we need it? What is the purpose of a staging area?

10. What is Global and Local shortcut. explain with advantages

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

12. Lets suppose we have some 10,000 odd records in source system and when load them into target how do we ensure that all 10,000 records that are loaded to target doesn't contain any garbage values. How do we test it. We can't check every record as number of records are huge.

13. In what scenario ETL coding is preferred than Database level SQL,PL/SQL coding?

14. What is the Difference between a ODS and Staging Area

15. Can we override a native sql query within Informatica? Where do we do it? How do we do it?

16. What are the different Lookup methods used in Informatica?

17. How you capture changes in data if the source system does not have option of storing date/time field in source table from where you need to extract the data?

18. Can we use procedural logic inside Infromatica? If yes how , if now how can we use external procedural logic in informatica?

19. what is the difference between etl tool and olap tools

20. If LKP on target table is taken, can we update the rows without update strategy transformation?

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

22. what is ODS (operation data source)

23. What are push and pull etl strategies?


24. In real time scenario where update strategy transformation is used?if we dml operations in session properties then what is the use of update strategy transforamtion ?


25. What are the various transformation available?

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

27. What is Entity relation?? How is works with Datawarehousing ETL modeling???

28. How do we call shell scripts from informatica?

29. What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA.

30. where do we use connected and un connected lookups

31. What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

32. where do we use connected and un connected loops

33. What is a three tier data warehouse?

34. how do you tell aggregator stage that input data is already sorted

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

36. Can anyone please explain why and where do we exactly use the lookup tranformations.thanks in advacnethanksnayana

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

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

39. 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.RegRam

40. where do we use semi and non additive facts

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

42. Compare ETL & Manual development?

43. can we lookup a table from source qualifier transformation. ie. unconnected lookup

44. Can Informatica load heterogeneous targets from heterogeneous sources?

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

46. what is the metadata extension?

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

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

49.
50. How do you implement the concept of reusability in Microstrategy?( As in Informatica it is done by creating mapplets.) How to determine what records to extract?

51. What are the modules in Power Mart?

52. How can we use mapping variables in Informatica? Where do we use them?

53. Techniques of Error Handling - Ignore , Rejecting bad records to a flat file , loading the records