Parshu.

Very Very important Video For Interview Part 1 SQL INTERVIEW QUESTIONS FOR DATA ANALYST|SQL INTERVIEW QUESTIONS FOR BUSINESS ANALYST| SQL QUESTIONS Part 2 SQL INTERVIEW QUESTIONS PART 2 |SQL INTERVIEW QUESTIONS FOR DATA/BUSINESS ANALYST| SQL QUESTIONS Q. What are SCD’s ? Q. Difference between SCD1, SCD2, SCD3. Tech Coach Channel Ans-----   SCD: Slowly changing dimensions explained with real examples   Q. What are Surrogate Keys ? Q. Difference between primary key and surrogate key.," Tech Coach Channel Ans------ Types of Keys in Database |Primary Key |Candidate Key |Super Key |Surrogate Key| Natural Key         Primary Key Surrogate Key 1.Primary Key is used to maintain unique records in OLTP system 1.surrogate Key is used to maintain Unique records in DWH system. 2. Primary Key values are entered by the user. 2.Surrogate Key values are generated by the system. (By ETL Mechanism) 3.Primary Key values can be alpha-numeric (can be characters,n...