American Express
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Naukri.com and was interviewed before Apr 2020. There were 3 interview rounds.
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.
1 Interview rounds
based on 17 reviews
Rating in categories
Business Analyst
882
salaries
| ₹9.5 L/yr - ₹17 L/yr |
Assistant Manager
697
salaries
| ₹14 L/yr - ₹42 L/yr |
Senior Analyst
568
salaries
| ₹5.2 L/yr - ₹23 L/yr |
Lead Analyst
548
salaries
| ₹4 L/yr - ₹13 L/yr |
Analyst
502
salaries
| ₹13.1 L/yr - ₹28 L/yr |
MasterCard
Visa
PayPal
State Bank of India