What is Delta loading in SSIS?
Delta loading nothing but incremental loading in place of full loading. Casually date columns like ModifyDate, Change Date or UpdatedDate etc. are used.
For example
Select col1,col2... From Products where UpdatedDate>'2013-10-12'
What is Proxy account?
Microsoft SQL Server Agent proxy accounts define a security context in which a job step can run. To set permissions for a particular job step, create a proxy that has the required permissions for a SQL Server Agent subsystem, and then assign that proxy to the job step. Only members of the sysadmin fixed server role have permission to create, modify, or delete proxy accounts. Users who are not members of the sysadmin fixed server role must be added to one of the following SQL Server Agent fixed database roles in the msdb database to use proxies: SQLAgentUserRole, SQLAgentReaderRole, or SQLAgentOperatorRole.
Steps to create Proxies.
1.Expand Sql server agent
2.Right click on Proxies
3.Creae new proxy
For detail information
http://technet.microsoft.com/en-us/library/ms190698%28v=sql.105%29.aspx
Delta loading nothing but incremental loading in place of full loading. Casually date columns like ModifyDate, Change Date or UpdatedDate etc. are used.
For example
Select col1,col2... From Products where UpdatedDate>'2013-10-12'
What is Proxy account?
Microsoft SQL Server Agent proxy accounts define a security context in which a job step can run. To set permissions for a particular job step, create a proxy that has the required permissions for a SQL Server Agent subsystem, and then assign that proxy to the job step. Only members of the sysadmin fixed server role have permission to create, modify, or delete proxy accounts. Users who are not members of the sysadmin fixed server role must be added to one of the following SQL Server Agent fixed database roles in the msdb database to use proxies: SQLAgentUserRole, SQLAgentReaderRole, or SQLAgentOperatorRole.
Steps to create Proxies.
1.Expand Sql server agent
2.Right click on Proxies
3.Creae new proxy
For detail information
http://technet.microsoft.com/en-us/library/ms190698%28v=sql.105%29.aspx
Good Stuff.... Vara....
ReplyDeletecan you post some stuff related to ssas .....
sure purushotham , any way you can find some SSAS topics in other posts
Deletehttp://ssas-cube.blogspot.in/2013/06/cube-processing-options.html
http://ssas-cube.blogspot.in/2013/06/ssas-cube-designer-tabs.html
http://ssas-cube.blogspot.in/2013/08/calculations-in-analysis-services.html
http://ssas-cube.blogspot.in/2013/08/different-types-of-relationships.html
http://ssas-cube.blogspot.in/2013/08/dimension-attribute-properties.html
etc...