For update part of ETL Process I have to write another Common table expression to get all records where are changed at source to run update query on destination table My update part of basic ETL using TSQL as with ChangedRows as ( SELECT sourceEmp.empid, sourceEmp.lastname, sourceEmp.firstname, sourceEmp.title, sourceEmp.titleofcourtesy, sourceEmp.birthdate, sourceEmp.hiredate, sourceEmp.address, […]
SQL Server 2008
http://bidshelper.codeplex.com/ There are many advantages in using this tool… 1. The first thing which I use this is for checking the dimension health, this is very helpful especially when you are dealing with the hierarchies…this helps in checking the data which is violating the hierarchy rule like data with many to many relationship etc… 2. […]
Main object is sys.tables. you can get all information about tables by query on sys.tables. User databasename Select * from sys.tables;. SELECT SCHEMA_NAME(schema_id) AS table_schema_name, name AS table_Name FROM sys.tables; SCHEMA_NAME convert schema_id into schema name.