Profile cover photo
Profile photo
RISHI SAXENA
15 followers -
A professional with extensive experience in High-performance Data Integration Solutions using MSBI Technologies.
A professional with extensive experience in High-performance Data Integration Solutions using MSBI Technologies.

15 followers
About
Posts

Post has attachment
Dynamic Data Load - SSIS
I was recently tasked with loading tab-delimited flat
files into a staging table on SQL Server database. On the very 1 st look, the requirement looks straight forward isn’t it? But there is a catch.
The format of the file was not fixed and there can be vary...

Post has attachment
Dynamic Data Load - SSIS
I was recently tasked with loading tab-delimited flat
files into a staging table on SQL Server database. On the very 1 st look, the requirement looks straight forward isn’t it? But there is a catch.
The format of the file was not fixed and there can be vary...

Post has attachment
Deleting Millions of Records in SQL
How many of you have tasked with purging/archiving
records from one of the biggest table of your data warehouse solution. The
scenario looks quite common and I am pretty much sure everyone gets a chance to
work on tasks like these sometime during their carr...

Post has attachment
Data Testing & Automated Unit Test Framework - ETL Process
Data Testing is yet another important but mostly
forgotten component of ETL development life cycle. A good ETL solution is
incomplete without a good unit test framework. Complexity of a project increases as more &
more business rules are added to the packag...

Post has attachment
Decoding Data Mapping Sheets - ETL Process
An ETL ( E xtract T ransform L oad) process is all about moving a variety of data from Source System
to the destination Data Warehouse System by taking data through a number of
extraction, transformation, data cleansing & data validation processes. Just ima...

Post has attachment
Decoding Data Mapping Sheets - ETL Process
An ETL ( E xtract T ransform L oad) process is all about moving a variety of data from Source System
to the destination Data Warehouse System by taking data through a number of
extraction, transformation, data cleansing & data validation processes. Just ima...

Post has attachment
Database Design Consideration
So, this is my 2 nd blog which details various
database design consideration that one should follow while developing database
design. This is just a high-level overview of guidelines that I normally follow.
The list is not exhaustive, so there will be a few...

Post has attachment
**
A
quick introduction to BIDS & MSBI: So, after thinking about writing a
blog for quite some time, this is my first attempt at blogging. I have gained a
lot of technical information as I grew as a professional over the years, thanks
to all the active blogger...
Wait while more posts are being loaded