Morgan Stanley Quality Assurance Interview Questions and Answers for Experienced

SCD Type 2 is a technique used to track historical changes in data over time in a data warehouse.

• SCD Type 2 maintains a separate row for each change in data, with a start and end date.

• It requires a surrogate key to uniquely identify each row.

• Informatica provides a built-in SCD Type 2 transformation to implement this technique.

• Example: tracking changes in customer addresses over time.

A bond is a debt security that represents a loan made by an investor to a borrower.

• Bonds are issued by corporations, municipalities, and governments to raise capital.

• They have a fixed interest rate and a maturity date when the principal is repaid.

• Bonds are generally considered less risky than stocks but offer lower potential returns.

• Investors can buy and sell bonds on the secondary market.

• Examples of bonds include U.S....read more

Fund Accounting is a specialized accounting system used by non-profit organizations and government agencies to track and manage funds.

• It involves tracking and reporting on the financial activity of specific funds or grants.

• It ensures that funds are used for their intended purposes and that financial reports are accurate and transparent.

• Examples include tracking donations to a non-profit organization or managing governm...read more