blogs.drivetoexcel.com
Partiitioned Primary Index – DrivetoExcel.com
http://blogs.drivetoexcel.com/partiitioned-primary-index
17 July, 2014. Partitioned Primary Index is an indexing mechanism in Teradata database that is used for distribution of rows based on different partition. The idea behind partitioning is to put similar rows together and allow database to access only particular partition instead of full table scan. Lets talk about the usage of PPI and what are the concept behind partition a table. Partitioned Primary Index Rules / Advantage:. A table can have up to 65,535 Partitions. Create Table Employee PPI. First Name ...
blogs.drivetoexcel.com
SQL Server View – DrivetoExcel.com
http://blogs.drivetoexcel.com/sql-server-view
11 September, 2014. View is a virtual table, which contains rows and columns based on the DML query being used to fetch the result-set. In another words, we can say view is clone of a real table with specifeid fileds need to be dislayed from one or more than one table columns. Here you will see rows and columns from real table (physical table) as shown below. 3761 N. 14th St. Create view View Name. As select column1, column2, column3. Select CustID,firstName,LastName,Gender. Select * from CustomerInfo.
blogs.drivetoexcel.com
SQL Server – DrivetoExcel.com
http://blogs.drivetoexcel.com/category/sql-server
Introducing User-Defined Variables – SSIS. 6 January, 2015. Here you will learn about scope of variable in your packages. Variables is a named object that store values which can be used by SQL package and its containers, tasks, and event handlers at … Continue Reading →. 11 September, 2014. View is a virtual table, which contains rows and columns based on the DML query being used to fetch the result-set. In another words, we can say view is clone … Continue Reading →. 3 April, 2014. 11 March, 2014. Micro...
blogs.drivetoexcel.com
Type of Joins – DrivetoExcel.com
http://blogs.drivetoexcel.com/type-of-joins
3 April, 2014. Join is fetching data from two or more tables based on common column (fields) between the tables. Here we will be talking Employee. Tables to understand the different type of joins. Our Demo Tables. There are many types of join. Non-Equi Join (also known as Natural Join). Returns only the matching rows between the tables. To retrieve the matching rows between Employee and Department Table. Kindly see the example below. Select e.empID,e.EmpName,d.DeptName from Employee e. 8211; EQUI Join.
blogs.drivetoexcel.com
About us – DrivetoExcel.com
http://blogs.drivetoexcel.com/category/about-us
Apologies, but no results were found for the requested archive. Perhaps searching will help find a related post. Teradata IN limit to the number of arguments. Type of Dimension’s. Introducing User-Defined Variables – SSIS. Toad application is not working properly. Find Us on Facebook. We welcome any feedback, questions or comments. Leave This Field Empty.
blogs.drivetoexcel.com
Tables in MultiLoad – DrivetoExcel.com
http://blogs.drivetoexcel.com/tables-in-multiload
14 July, 2014. 8211; Data error. MultiLoad uses the ET table, also called the Acquisition Phase error table, to store data errors found during the acquisition phase of a MultiLoad import task. 8211; UPI violations. MultiLoad uses the UV table, also called the Application Phase error table, to store data errors found during the application phase of a MultiLoad import or delete task. Apart from error tables, it also has work and log tables. Mload loads the selected records in the work table.
blogs.drivetoexcel.com
TeraData – DrivetoExcel.com
http://blogs.drivetoexcel.com/category/teradata
Type of Dimension’s. 16 February, 2015. 1) Confirmed Dimension 2) Degenerated Dimension 3) Junk Dimension 4) Dirty Dimension 5) Slowing changing Dimension Conformed Dimension The dimension which is shared by two or more fact tables in … Continue Reading →. 11 February, 2015. In data warehouse design, frequently we run into a situation where there are yes/no indicator and flag fields in the source system. These flags do not logically belong to the core … Continue Reading →. 17 July, 2014. 14 July, 2014.
blogs.drivetoexcel.com
DrivetoExcel.com – Page 2 – Talent Navigator
http://blogs.drivetoexcel.com/page/2
SCD is Slowing Changing Dimension, dimensions that change slowly over time, rather than changing on regular schedule, time-base. For example- if we talks about Employee – Employee designation and Location … Continue Reading →. FastLoad is a command-driven utility you can use to quickly load large amounts of data in an empty table :- to load empty tables at high speed and one table … Continue Reading →. 14 July, 2014. 14 July, 2014. Oracle 11g – Trouble shooting Case Statement with OLEDB. 13 May, 2014.
blogs.drivetoexcel.com
Slowly Changing Dimension – DrivetoExcel.com
http://blogs.drivetoexcel.com/slowly-changing-dimension
27 March, 2014. SCD is Slowing Changing Dimension, dimensions that change slowly over time, rather than changing on regular schedule, time-base. For example- if we talks about Employee – Employee designation and Location change over time and Employee gets married and marital status change etc. SCD are mainly categories into three type namely Type1, Type2, Type3. In Data Warehouse architecture. 8211; overwriting old values. 8211; Creating an another additional records. Adding a attribute are not that big ...
SOCIAL ENGAGEMENT