Tuesday, 3 February 2015

ETL Testing Part5 Interview Questions and Answers for freshers and experienced pdf

41. What is worklet?
The worklet is a group of sessions. To execute the worklet we have to create the workflow.

42. Why we use lookup transformation?
Look up Transformations can access data from relational tables that are not sources in mapping. With Lookup transformation, we can accomplish the following tasks.

43. What is a Power Center Repository?
The Power Center Repository allows you to share metadata across repositories to create a data mart domain. In a data mart domain, you can create a single global repository to store metadata used across an enterprise and a number of local repositories to share the global metadata as needed.

44. What are snapshots? What are materialized views & where do we use them? What is a materialized view?
Materialized view is a view in which data is also stored in some temp table.i.e if we will go with the View concept in DB in that we only store query and once we call View it extract data from DB. But In materialized View data is stored in some temp tables.

45. Where do we use connected and un connected lookups?
If return port only one then we can go for unconnected. More than one return port is not possible with Unconnected. If more than one return port then go for Connected.
If you require dynamic cache i.e where your data will change dynamically then you can go for connected lookup. If your data is static where your data won't change when the session loads you can go for unconnected lookups
More Questions & Answers :-
Part1  Part2  Part3  Part4  Part5

No comments:

Post a Comment