This video tutorial is to understand the working of sequences in oracle SQL. The video demonstrations explain all the attributes of a create sequence statement such as start with, increment by, maxvalue, nomaxvalue, minvalue, nominvalue, cycle, nocycle, cache, nocache, order, and noorder. All the parameters are explained with appropriate examples so that the user can understand them clearly.
For more detail refer to the link:
http://plsqlnsql.blogspot.com/2017/01/sequences.html

Oracle tutorial: How to create Id with AUTO INCREMENT in Oracle
oracle tutorial for beginners
sequence in oracle
identity key in sql
In this Oracle tutorial , we can create an auto increment field using ‘sequence’
object that can be assigned as primary keys.
Using Oracle ‘sequence’ object, you can generate new values for a column.
An Oracle sequence is an object like a table or a stored procedure.
Examples
CREATE SEQUENCE SYSTEM.MYSEQ
START WITH 1
MAXVALUE 999999999999999999999999999
MINVALUE 1
NOCYCLE
CACHE 20
NOORDER;
CREATE OR REPLACE TRIGGER TR_CITY BEFORE INSERT ON CITY FOR EACH ROW
BEGIN SELECT LPAD(LTRIM(RTRIM(TO_CHAR(myseq.NEXTVAL))),10,'0') INTO :NEW.id FROM DUAL;
END;
/
Subscribe on youtube:
https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA
For more tutorial please visit #techquerypond
https://techquerypond.wordpress.com
https://twitter.com/techquerypond

This tutorial is all about Sequence In Oracle Database. In this SQL Tutorial you will learn How to create a sequence How to populate a Primary key column (auto increment in Oracle) using Sequence How to drop a sequence
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : http://bit.ly/sql-sequence-in-oracle-database-rebellionrider-manish-sharma
Previous Tutorial
► How To Insert Data into Table using SQL Developer
http://youtu.be/YYQCSV6MzTk
► INSERT INTO Command
http://youtu.be/uQXgqFtxI_k
► How to copy /Insert data into a table from another table
http://youtu.be/m3Ep8tAMqok
-------------------------------------------------------------------------
►►►Help Me In Getting A Job◄◄◄
►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company
Thanks
-------------------------------------------------------------------------
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
https://copy.com?r=kb4rc1
--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
--------------------------------------------------------------------------
Amazon Wishlist: http://bit.ly/wishlist-amazon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/
You can also Email me at
for E-mail address please check About section
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

Link for all dot net and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
Link for slides, code samples and text version of the video
http://csharp-video-tutorials.blogspot.com/2014/05/part-1-how-to-find-nth-highest-salary_17.html
This is a very common SQL Server Interview Question. There are several ways of finding the nth highest salary.
By the end of this video, we will be able to answer all the following questions as well.
How to find nth highest salary in SQL Server using a Sub-Query
How to find nth highest salary in SQL Server using a CTE
How to find the 2nd, 3rd or 15th highest salary
Let's use the following Employees table for this demo
Use the following script to create Employees table
Create table Employees
(
ID int primary key identity,
FirstName nvarchar(50),
LastName nvarchar(50),
Gender nvarchar(50),
Salary int
)
GO
Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000)
Insert into Employees values ('Mark', 'Hastings', 'Male', 60000)
Insert into Employees values ('Steve', 'Pound', 'Male', 45000)
Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000)
Insert into Employees values ('Philip', 'Hastings', 'Male', 45000)
Insert into Employees values ('Mary', 'Lambeth', 'Female', 30000)
Insert into Employees values ('Valarie', 'Vikings', 'Female', 35000)
Insert into Employees values ('John', 'Stanmore', 'Male', 80000)
GO
To find the highest salary it is straight forward. We can simply use the Max() function as shown below.
Select Max(Salary) from Employees
To get the second highest salary use a sub query along with Max() function as shown below.
Select Max(Salary) from Employees where Salary [ (Select Max(Salary) from Employees)
To find nth highest salary using Sub-Query
SELECT TOP 1 SALARY
FROM (
SELECT DISTINCT TOP N SALARY
FROM EMPLOYEES
ORDER BY SALARY DESC
) RESULT
ORDER BY SALARY
To find nth highest salary using CTE
WITH RESULT AS
(
SELECT SALARY,
DENSE_RANK() OVER (ORDER BY SALARY DESC) AS DENSERANK
FROM EMPLOYEES
)
SELECT TOP 1 SALARY
FROM RESULT
WHERE DENSERANK = N
To find 2nd highest salary we can use any of the above queries. Simple replace N with 2.
Similarly, to find 3rd highest salary, simple replace N with 3.
Please Note: On many of the websites, you may have seen that, the following query can be used to get the nth highest salary. The below query will only work if there are no duplicates.
WITH RESULT AS
(
SELECT SALARY,
ROW_NUMBER() OVER (ORDER BY SALARY DESC) AS ROWNUMBER
FROM EMPLOYEES
)
SELECT SALARY
FROM RESULT
WHERE ROWNUMBER = 3

create sequence in sql server
In this video we will discuss sequence object in SQL Server.
Sequence object
Introduced in SQL Server 2012
Generates sequence of numeric values in an ascending or descending order
Text version of the video
http://csharp-video-tutorials.blogspot.com/2015/10/sequence-object-in-sql-server-2012.html
Slides
http://csharp-video-tutorials.blogspot.com/2015/10/sequence-object-in-sql-server-2012_26.html
All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html
All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html
All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd
All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists
Creating the Incrementing Sequence : The following code create a Sequence object that starts with 1 and increments by 1
CREATE SEQUENCE [dbo].[SequenceObject]
AS INT
START WITH 1
INCREMENT BY 1
Generating the Next Sequence Value : Now we have a sequence object created. To generate the sequence value use NEXT VALUE FOR clause
SELECT NEXT VALUE FOR [dbo].[SequenceObject]
Output : 1
Every time you execute the above query the sequence value will be incremented by 1. I executed the above query 5 times, so the current sequence value is 5.
Retrieving the current sequence value : If you want to see what the current Sequence value before generating the next, use sys.sequences
SELECT *
FROM sys.sequences
WHERE name = 'SequenceObject'
Alter the Sequence object to reset the sequence value :
ALTER SEQUENCE [SequenceObject]
RESTART WITH 1
Select the next sequence value to make sure the value starts from 1
SELECT NEXT VALUE FOR [dbo].[SequenceObject]
Using sequence value in an INSERT query :
CREATE TABLE Employees
(
Id INT PRIMARY KEY,
Name NVARCHAR(50),
Gender NVARCHAR(10)
)
-- Generate and insert Sequence values
INSERT INTO Employees VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Ben', 'Male')
INSERT INTO Employees VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Sara', 'Female')
-- Select the data from the table
SELECT * FROM Employees
Creating the decrementing Sequence : The following code create a Sequence object that starts with 100 and decrements by 1
CREATE SEQUENCE [dbo].[SequenceObject]
AS INT
START WITH 100
INCREMENT BY -1
Specifying MIN and MAX values for the sequence : Use the MINVALUE and MAXVALUE arguments to specify the MIN and MAX values respectively.
Step 1 : Create the Sequence object
CREATE SEQUENCE [dbo].[SequenceObject]
START WITH 100
INCREMENT BY 10
MINVALUE 100
MAXVALUE 150
Step 2 : Retrieve the next sequence value. The sequence value starts at 100. Every time we call NEXT VALUE, the value will be incremented by 10.
SELECT NEXT VALUE FOR [dbo].[SequenceObject]
If you call NEXT VALUE, when the value reaches 150 (MAXVALUE), you will get the following error
The sequence object 'SequenceObject' has reached its minimum or maximum value. Restart the sequence object to allow new values to be generated.
Recycling Sequence values : When the sequence object has reached it's maximum value, and if you want to restart from the minimum value, set CYCLE option
ALTER SEQUENCE [dbo].[SequenceObject]
INCREMENT BY 10
MINVALUE 100
MAXVALUE 150
CYCLE
At this point, whe the sequence object has reached it's maximum value, and if you ask for the NEXT VALUE, sequence object starts from the minimum value again which in this case is 100.
To improve performance, the Sequence object values can be cached using the CACHE option. When the values are cached they are read from the memory instead of from the disk, which improves the performance. When the cache option is specified you can also specify the size of th cache , that is the number of values to cache.
The following example, creates the sequence object with 10 values cached. When the 11th value is requested, the next 10 values will be cached again.
CREATE SEQUENCE [dbo].[SequenceObject]
START WITH 1
INCREMENT BY 1
CACHE 10
Using SQL Server Graphical User Interface (GUI) to create the sequence object :
1. Expand the database folder
2. Expand Programmability folder
3. Right click on Sequences folder
4. Select New Sequence
Next video : Difference between SEQUENCE and IDENTITY in SQL Server

sql server identity vs sequence
In this video we will discuss the difference between SEQUENCE and IDENTITY in SQL Server
This is continuation to Part 134. Please watch Part 134 from SQL Server tutorial before proceeding.
Sequence object is similar to the Identity property, in the sense that it generates sequence of numeric values in an ascending order just like the identity property. However there are several differences between the 2 which we will discuss in this video.
Identity property is a table column property meaning it is tied to the table, where as the sequence is a user-defined database object and is not tied to any specific table meaning it's value can be shared by multiple tables.
Example : Identity property tied to the Id column of the Employees table.
CREATE TABLE Employees
(
Id INT PRIMARY KEY IDENTITY(1,1),
Name NVARCHAR(50),
Gender NVARCHAR(10)
)
Example : Sequence object not tied to any specific table
CREATE SEQUENCE [dbo].[SequenceObject]
AS INT
START WITH 1
INCREMENT BY 1
This means the above sequence object can be used with any table.
Example : Sharing sequence object value with multiple tables.
Step 1 : Create Customers and Users tables
CREATE TABLE Customers
(
Id INT PRIMARY KEY,
Name NVARCHAR(50),
Gender NVARCHAR(10)
)
GO
CREATE TABLE Users
(
Id INT PRIMARY KEY,
Name NVARCHAR(50),
Gender NVARCHAR(10)
)
GO
Step 2 : Insert 2 rows into Customers table and 3 rows into Users table. Notice the same sequence object is generating the ID values for both the tables.
INSERT INTO Customers VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Ben', 'Male')
INSERT INTO Customers VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Sara', 'Female')
INSERT INTO Users VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Tom', 'Male')
INSERT INTO Users VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Pam', 'Female')
INSERT INTO Users VALUES (NEXT VALUE for [dbo].[SequenceObject], 'David', 'Male')
GO
Step 3 : Query the tables
SELECT * FROM Customers
SELECT * FROM Users
GO
Output : Notice the same sequence object has generated the values for ID columns in both the tables
To generate the next identity value, a row has to be inserted into the table, where as with sequence object there is no need to insert a row into the table to generate the next sequence value. You can use NEXT VALUE FOR clause to generate the next sequence value.
Example : Generating Identity value by inserting a row into the table
INSERT INTO Employees VALUES ('Todd', 'Male')
Example : Generating the next sequence value using NEXT VALUE FOR clause.
SELECT NEXT VALUE FOR [dbo].[SequenceObject]
Maximum value for the identity property cannot be specified. The maximum value will be the maximum value of the correspoding column data type. With the sequence object you can use the MAXVALUE option to specify the maximum value. If the MAXVALUE option is not specified for the sequence object, then the maximum value will be the maximum value of it's data type.
Example : Specifying maximum value for the sequence object using the MAXVALUE option
CREATE SEQUENCE [dbo].[SequenceObject]
START WITH 1
INCREMENT BY 1
MAXVALUE 5
CYCLE option of the Sequence object can be used to specify whether the sequence should restart automatically when the max value (for incrementing sequence object) or min value (for decrementing sequence object) is reached, where as with the Identity property we don't have any such option to automatically restart the identity values.
Example : Specifying the CYCLE option of the Sequence object, so the sequence will restart automatically when the max value is exceeded
CREATE SEQUENCE [dbo].[SequenceObject]
START WITH 1
INCREMENT BY 1
MINVALUE 1
MAXVALUE 5
CYCLE
Text version of the video
http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-sequence-and.html
Slides
http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-sequence-and_27.html
All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html
All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html
All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd
All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

get maximum value from htm table in javascript
Source Code: https://1bestcsharp.blogspot.com/2017/08/javascript-html-table-maximum-value.html
Javascript Tutorials For Beginners ➜ http://bit.ly/2k7NMWq
Javascript Course For Beginners ➜ http://bit.ly/2IvBCFC
visit our blog https://1bestcsharp.blogspot.com/
subscribe: http://goo.gl/nRjPKk
In This Javascript Tutorial we will See How To Find The Max Value In An HTML Table Column Using For Loop With If Condition And Display The MAX Value In Span Tag Using Netbeans Editor .
More Javascript Tutorials :
get minimum value from html table
https://www.youtube.com/watch?v=KU_fUfdIhFM
get sum value
https://www.youtube.com/watch?v=2p39swI3_Rs
get avg value
https://www.youtube.com/watch?v=zeJ4lKgUqig
How to get value of selected radio button
https://www.youtube.com/watch?v=uzwUBDQfpkU
How to append Value to an array
https://www.youtube.com/watch?v=KVdY8n6lCy4
javascript images slider 1
https://www.youtube.com/watch?v=QkcemPr4xaU
Convert String To Number
https://www.youtube.com/watch?v=JMfZG7o_QtE
JavaScript Show And Hide Input Password Text
https://www.youtube.com/watch?v=Cmo9sjx5eFE
change div class name in js
https://www.youtube.com/watch?v=X_SDJxKI6HE
using checkbox with js
https://www.youtube.com/watch?v=yFYEHSh2iTQ
get And Set Value To An Input
https://www.youtube.com/watch?v=AfRHl3soLDg
Search Element In Array
https://www.youtube.com/watch?v=LIsjSMr9bJU
Add Search Remove Array Element
https://www.youtube.com/watch?v=ppLbuVWf6zM
Add HTML Table Row
https://www.youtube.com/watch?v=FVSfp8yT8lA
Get Mouse Position
https://www.youtube.com/watch?v=LVi5DN2vtdo

Kerberos /ˈkɛərbərəs/ is a computer network authentication protocol which works on the basis of 'tickets' to allow nodes communicating over a non-secure network to prove their identity to one another in a secure manner. Its designers aimed it primarily at a client–server model and it provides mutual authentication—both the user and the server verify each other's identity. Kerberos protocol messages are protected against eavesdropping and replay attacks.
Kerberos builds on symmetric key cryptography and requires a trusted third party, and optionally may use public-key cryptography during certain phases of authentication. Kerberos uses UDP port 88 by default.
This video is targeted to blind users.
Attribution:
Article text available under CC-BY-SA
Creative Commons image source in video

range vs rows in sql server
difference between rows clause and range clause in sql server
range clause vs rows clause in sql server
sql server running total query
running total example in sql server
In this video we will discuss the difference between rows and range in SQL Server. This is continuation to Part 116. Please watch Part 116 from SQL Server tutorial before proceeding.
Let us understand the difference with an example. We will use the following Employees table in this demo.
SQL Script to create the Employees table
Create Table Employees
(
Id int primary key,
Name nvarchar(50),
Salary int
)
Go
Insert Into Employees Values (1, 'Mark', 1000)
Insert Into Employees Values (2, 'John', 2000)
Insert Into Employees Values (3, 'Pam', 3000)
Insert Into Employees Values (4, 'Sara', 4000)
Insert Into Employees Values (5, 'Todd', 5000)
Go
Calculate the running total of Salary and display it against every employee row
The following query calculates the running total. We have not specified an explicit value for ROWS or RANGE clause.
SELECT Name, Salary,
SUM(Salary) OVER(ORDER BY Salary) AS RunningTotal
FROM Employees
So the above query is using the default value which is
RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
This means the above query can be re-written using an explicit value for ROWS or RANGE clause as shown below.
SELECT Name, Salary,
SUM(Salary) OVER(ORDER BY Salary
RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal
FROM Employees
We can also achieve the same result, by replacing RANGE with ROWS
SELECT Name, Salary,
SUM(Salary) OVER(ORDER BY Salary
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal
FROM Employees
What is the difference between ROWS and RANGE
To understand the difference we need some duplicate values for the Salary column in the Employees table.
Execute the following UPDATE script to introduce duplicate values in the Salary column
Update Employees set Salary = 1000 where Id = 2
Update Employees set Salary = 3000 where Id = 4
Go
Now execute the following query. Notice that we get the running total as expected.
SELECT Name, Salary,
SUM(Salary) OVER(ORDER BY Salary
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal
FROM Employees
The following query uses RANGE instead of ROWS
SELECT Name, Salary,
SUM(Salary) OVER(ORDER BY Salary
RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal
FROM Employees
Notice we don't get the running total as expected.
So, the main difference between ROWS and RANGE is in the way duplicate rows are treated. ROWS treat duplicates as distinct values, where as RANGE treats them as a single entity.
All together side by side. The following query shows how running total changes
1. When no value is specified for ROWS or RANGE clause
2. When RANGE clause is used explicitly with it's default value
3. When ROWS clause is used instead of RANGE clause
SELECT Name, Salary,
SUM(Salary) OVER(ORDER BY Salary) AS [Default],
SUM(Salary) OVER(ORDER BY Salary RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS [Range],
SUM(Salary) OVER(ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS [Rows]
FROM Employees
Text version of the video
http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-rows-and-range.html
Slides
http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-rows-and-range_8.html
All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html
All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html
All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd
All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to : Extract Records Between Two Dates: Filter or Formula:
1. Static Data: Filter using Between Crteria and then copy and paste
2. Data that changes use formula for dynamic results that update instantly. See array formula that uses COUNTIFS, INDEX, SMALL ROWS, ROW and IF Functions.
3. See the the Excel 2007 function: IFERROR
4. See the 2010 Function AGGREGATE
5. See the Excel 2003 function COUNTIF

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/10/calling-stored-procedure-with-output.html
Slides
http://csharp-video-tutorials.blogspot.com/2013/09/part-7-calling-stored-procedure-with.html
All ADO .NET Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-adonet-video-tutorial.html
All ADO .NET Slides
http://csharp-video-tutorials.blogspot.com/p/adonet-slides.html
All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd
All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists
In this video, we will learn about calling a stored procedure with output parameters from an asp.net web application.

In this tutorial I will explain how to fetch auto increment value to textbox from database in c#.
I have created form Registration where User will enter his details like name,address etc.the userid will be generated automatically. i have created table with Userid column made it as identity
when user clicks on the this form i have textbox userid this textbox should display this auto genereated id.

In this video we will learn
1. Retrieve the last generated identity column value
2. Difference between SCOPE_IDENTITY(), @@Identity and IDENT_CURRENT('TableName')
Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/how-to-get-last-generated-identity.html
Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-8-retrieving-identity-column-values.html
All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html
All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html
All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd
All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

Learn how to improve the Performance of validation procedures in Oracle Clinical. --
Ensuring the validity of patient data in your clinical data management and EDC system is essential. However, without a way to programmatically identify discrepancies and inconsistencies, such a task can inadvertently leave bad data in your system. Through validation procedures, an endless assortment of expressions and formulas, Oracle Clinical offers the powerful ability to clean and compare patient data.
In this webinar, Perficient's Dr. Steve Rifkin, a leading expert in Oracle Clinical, discussed the structure of validation procedures, as well as provide various tips and techniques for developing procedures that improve the performance of edit checks.
Stay on top of Life Sciences technologies by following us here:
Twitter: http://www.twitter.com/Perficient_LS
Facebook: http://www.facebook.com/Perficient
LinkedIn: http://www.linkedin.com/company/165444
Google+: https://plus.google.com/+Perficient
SlideShare: http://www.slideshare.net/PerficientInc

The Remove Duplicates stage is a processing stage. It can have a single input link and a single output link.
The Remove Duplicates stage takes a single sorted data set as input, removes all duplicate rows, and writes the results to an output data set.
Removing duplicate records is a common way of cleansing a data set before you perform further processing. Two rows are considered duplicates if they are adjacent in the input data set and have identical values for the key column(s). A key column is any column you designate to be used in determining whether two rows are identical.
The data set input to the Remove Duplicates stage must be sorted so that all records with identical key values are adjacent. You can either achieve this using the in-stage sort facilities available on the Input page Partitioning tab, or have an explicit Sort stage feeding the Remove Duplicates stage.

This video demonstrates how to handle an incremental data load / delta load. It also demonstrates how to read value from a config file and assign it to the context variable.
Components used:
**********************
tFileInputDelimited
tContextLoad
tJava
tMysqlInput
tMap
tAggregateRow
tJavaRow
tLogRow
tRowGenerator
tFileOutputDelimited
Note: No voice in this demonstration.
Its mainly targeted for self-paced learning.
Music: Magic Marker

You all know I have no problem working all night, and after all the apologies, I assured Anastasia it wasnt a problem, and we worked till midnight, with Anastasia emerging as another early candidate for Miss Bald USA. At a minimum, she should win Miss Wisconsin and Miss Congeniality, but probably not Miss Punctuality.
Is Anastasia the BEST BALD CHICK EVER? Shes got my vote, and Im guessing she will win a lot of votes from our community!!
Anastasias hair is long, silky Pantene hair, and its all coming off tonight!!
Her figure is Miss America PERFECT, and soon she will be shaved to silky smooth perfection!! A GODDESS AMONG WOMEN!! What a way to celebrate the Fourth of July!!
She loves her new haircut, and cant wait to show off her new BALD BEAUTY to her friends!!
UPDATE ON THE NEW BETA PLAYER- 1,900 VIDEOS NOW SHOWING.
LOOKING FOR A FEW GOOD MEN (AND WOMEN)
TO TEST THE NEW BETA PLAYER ON THE SUB SITE.

We plan to move over 500 videos from Channel 1, which currently contains 747 videos, to Channels 5, 6, 7, 8 and 9 to speed up loading.
Channels 2, 3 and 4 now have 100-200 videos each with good loading speeds.
Current plans call for Channel 10 to be used for Live Haircut Broadcasts.
BIG SAVINGS ON ONE YEAR AND TWO YEAR SUBSCRIPTIONS, and the one month subscription of $33 is STILL CHEAP, so please help us if you can!!
Zoey smiled as the clippers ran down the middle- later saying that was "the best part!"
In a FIRST EVER, Zoey brought her own razor, and asked to be shaved with it. We had no problem with that, using her 5 blade razor!!
Tune in tomorrow, same Bat Time, same Bat Channel.
BRAVE BRUNETTE BOMBSHELL BECOMES BALD BEAUTY.
Stay tuned, as were negotiating with several models, who are ready to go "SUPER SHORT" for the hottest days of the year!!
Tune in tomorrow, same Bat Time, same Bat Channel.
BOTH OF THESE YOUNG BEAUTIES SIGNED CONTRACTS.
Well sir, we wrote up TWO CONTRACTS, and both girls signed, and then we proceeded until SOMEONE changed her mind.
WHICH ONE SHAVED? NOW SHOWING on the sub site.
QUEEN DANIELLE III- LONG LIVE THE QUEEN!!