Mandar Gogate

IICS - 24 - Install, Configure & Un-Install - IICS Secure Agent On LINUX Environment

IICS - 22 - Slowly Changing Dim (SCD) - Type2 Implementation

IICS - 23 - Slowly Changing Dim (SCD) - Type3 Implementation

IICS - 21 - Retry failed Step in IICS Task Flow using Temp Variable and Jump Task

IICS - 20(b) - Parameterizing Source, & Target connection along with Folder & Map name

IICS - 18 - Incremental Load using Mapping Variable and Mapping Task

IICS - 20(a) - Param file creation for incremental load using task flow

IICS - 19 - Incremental Load using Mapping Parameter and Param File

IICS - 17 - Incremental Load using SubQuery & Flow Run Order

IICS - 16 - How to transpose Rows To Columns - with Exp and Agg or using Java Transformation

IICS - 15 - File Listener Component to trigger Task Flow

IICS - 14c - Parsing multiple JSON objects using Hierarchy Parser Transformation

IICS - 14b - Parsing JSON Object values with Primary & Foreign Key relationships

IICS - 14a - Parsing JSON Object using Hierarchical Schema & Hierarchy Parser Transformation

IICS - 13 - Calling Taskflow API using Swagger File & Webservice Transformation in IICS Mapping

IICS - 12 - Calling Login API using Swagger File & Webservice Transformation in IICS Mapping

IICS - 11 - Indirect File Load using FileList option

IICS - 10 - Dynamic File Creation Using Transaction Control Transformation

IICS - 9 - Running IICS-TaskFlow using DI - REST API

IICS - 8 - Metadata Query Using REST API - Login, Connection, Mapping, MappingTask

IICS - 7 - (upsert) Update Else Insert At Target

IICS - 6 - Dynamic Lookup Vs Static Lookup Transformation

IICS - 5 - Data Driven Insert-Update & Router Transformation with Static Lookup

IICS - 4 - Static Lookup & Manual Insert and Update Operation At Target

IICS - 3b - Aggregator, Joiner (Sorted Input) & Java Trans - Rows To Col Trans

IICS - 2 - Pass Through Mapping

IICS - 1 - Environment Creation

SQL Server Mirroring 6 - Forced Service Role Switching in SQL 2019 Mirroring

SQL Server Mirroring 5 - Manual Failover and Removing the mirroring

SQL Server Mirroring 4 - Pausing and Resuming Database Mirroring and Transaction Logs

SQL Server Mirroring 3 - Using First and Sub-Sequent Log Backup

SQL Server Mirroring 2 - Using Full & Log Backup

SQL Server Mirroring 1 - Using Full Backup

Replacing SAN in SQL Cluster - 8 :- Sanity check of SQL 2019 Cluster

Replacing SAN in SQL Cluster - 7 :- Changing quorum drive

Replacing SAN in SQL Cluster - 6 :- Changing path or registry entry for SQLAGENT.OUT

Replacing SAN in SQL Cluster - 5 :- Remove shared drives from cluster

Replacing SAN in SQL Cluster - 4 :- Moving master database and Startup Parameters

Replacing SAN in SQL Cluster - 3 :- Moving msdb, model & temp Databases

Replacing SAN in SQL Cluster - 2 :- Moving User Databases

Replacing SAN in SQL Cluster - 1 :- Configuring new Storage

Web Scraping IT Jobs - 6 :- Splinter for rescue

Web Scraping IT Jobs - 5 :- cursor.fetchall() from PostgreSQL

Web Scraping IT Jobs - 4 :- Get City & State Information

Web Scraping IT Jobs - 3 :- Insert into PostgreSQL

Web Scraping IT Jobs - 2 :- Beautiful Soup

Web Scraping IT Jobs - 1 :- Request.get method

SSRS - 10. Matrix Report

SSRS - 9. Stepped Report

SSRS - 8. Export data into multiple excel tabs & groups