PinnedTrunali·Feb 19, 2025DataWarehouse and DataLakeWhat is SCD(Slowly changing dimention) SCD1 and SCD2?
Trunali·Mar 4, 2025Interview questions: part 5Write a sql query for below scenario? Can you help to query all the consecutive available seats order by the seat_id using the following…
Trunali·Feb 24, 2025Apache DruidApache Druid is high time performance real-time analytical database. major focus area in data analytics industry:
Trunali·Feb 20, 2025KafkaAvro kafka has edge over Json Kafka? ->Avro is more compact in size(Smaller message size) — Avro uses binary encoding, reduce message size…
Trunali·Feb 19, 2025Python1.Explain the Singleton pattern and provide an example of how it can be implemented in Python.
Trunali·Feb 11, 2025Transactional SqlA transactional query in SQL is a sequence of one or more SQL statements that are executed as a single unit of work. Transactions ensure…
Trunali·Feb 10, 2025SQL1. How to split comma seperated values in same column to multiple rows in SQL?