Question.1 What is the difference between connected and unconnected transformation? Answer: Connected Transformation: Connected transformation is connected to other transformations or directly to target table in the mapping. Unconnected Transformation: An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns..
Question.1 What is Data warehouse? Answer: According to Bill Inmon, known as father of Data warehousing. “A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management’s decision making process”. Question.2 What are the types of data warehouses? Answer: There are three..